%iKnow.Objects.SQLUtils
hidden deprecated class %iKnow.Objects.SQLUtils extends %iKnow.Objects.StoredProcBase, %iKnow.Queries.AbstractQAPI
Method Inventory
- %DList()
- %List()
- CountTokens()
- CrcAsString()
- CreateDomainTables()
- DeleteDomain()
- DomainCoverage()
- FindRelatedClose()
- FindRelatedExecute()
- FindRelatedFetch()
- GetDomainTablesInfo()
- GetRelatedEntitiesClose()
- GetRelatedEntitiesExecute()
- GetRelatedEntitiesFetch()
- MatchCRC()
- PrintDomainCoverageReport()
- TopCUIList()
- TopEntitiesList()
Parameters
parameter %statementmetadata;
parameter %statementmetadata0;
parameter %statementmetadataext;
parameter %statementobjects;
Methods
classmethod %DList(class As %String, query As %String, col As %Integer, domainId As %Integer, args As %List) as %List [ SQLProc = %DList ]
Projected as the stored procedure: %DList
classmethod %List(class As %String, query As %String, col As %Integer, args As %List) as %List [ SQLProc = %List ]
Projected as the stored procedure: %List
classmethod CountTokens(str As %String, pattern As %String = "") as %Integer [ SQLProc = CountTokens ]
Projected as the stored procedure: CountTokens
classmethod CrcAsString(domain As %Integer, crcId As %Integer) as %String [ SQLProc = CRC_AS_STRING ]
Projected as the stored procedure: CRC_AS_STRING
classmethod CreateDomainTables(pTableName As %String, pColumnName As %String, ByRef pDomainName As %String = "", pIdColumn As %String = "", lang As %String = "", turnOffJournal As %Boolean = "", noindex As %Boolean = "") as %Status [ SQLProc = BuildDomainTables ]
Projected as the stored procedure: BuildDomainTables
Projected as the stored procedure: DeleteDomain
classmethod DomainCoverage(domainId As %Integer, topEntities As %Integer, margin As %Integer, type As %String = "ent", Output sc As %Status) as %Double [ SQLProc = DomainCoverage ]
Projected as the stored procedure: DomainCoverage
classmethod FindRelatedExecute(ByRef qHandle As %Binary, domainId As %Integer, entityValue As %String, similarity As %EnumString = 1) as %Status
classmethod FindRelatedFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status
classmethod GetDomainTablesInfo(domainId As %Integer, Output package As %String, Output schema As %String, Output refTable As %String, Output refId As %String) as %Status
classmethod GetRelatedEntitiesExecute(ByRef qHandle As %Binary, domainId As %Integer, entityId As %Integer) as %Status
classmethod GetRelatedEntitiesFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status
classmethod MatchCRC(domain As %Integer, crcId As %Integer, filter As %String = "", verbose As %Boolean = 0, xui As %String = "") as %String [ SQLProc = MATCH_CRC ]
Projected as the stored procedure: MATCH_CRC
classmethod PrintDomainCoverageReport(domainId As %Integer, t1 As %Integer, t2 As %Integer, t3 As %Integer, margin As %Integer, file As %String = "") as %Status
classmethod TopCUIList(domainId As %Integer, topEntities As %Integer, returnValues As %Boolean = 0, Output sc As %Status) as %List [ SQLProc = TopCUIList ]
Projected as the stored procedure: TopCUIList
classmethod TopEntitiesList(domainId As %Integer, topEntities As %Integer, returnValues As %Boolean = 0, Output sc As %Status) as %List [ SQLProc = TopEntitiesList ]
Projected as the stored procedure: TopEntitiesList
Queries
query FindRelated(domainId As %Integer, entityValue As %String, similarity As %EnumString = 1)
Searches for entities related to a given or similar string
Inherited Members
Inherited Properties
- %CurrentResult
- %Message
- %Metadata
- %OutputColumnCount
- %PrivateTables
- %ROWCOUNT
- %ROWID
- %ResultColumnCount
- %SQLCODE
- %StatementType
- %StatementTypeName
- lineNumber
- text
Inherited Methods
- %ClassIsLatestVersion()
- %ClassName()
- %CloseCursor()
- %ConstructClone()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %Display()
- %DisplayFormatted()
- %Extends()
- %Get()
- %GetData()
- %GetMetadata()
- %GetParameter()
- %GetSerializedMetadata()
- %IsA()
- %IsModified()
- %MoreResults()
- %New()
- %Next()
- %NextOutputValue()
- %NextResult()
- %NormalizeObject()
- %ObjectModified()
- %OnNew()
- %OpenCursor()
- %OriginalNamespace()
- %PackageName()
- %Print()
- %SendODBC()
- %SerializeObject()
- %SetModified()
- %ValidateObject()
- Close()
- Fetch()
- FetchRows()
- GetInfo()
- GetODBCInfo()
- getSelectMode()