Skip to main content

%iKnow.Objects.SQLUtils

Method Inventory

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
classmethod DeleteDomain(pDomainName As %String) as %Status [ SQLProc = DeleteDomain ]
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 FindRelatedClose(ByRef qHandle As %Binary) as %Status
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 GetRelatedEntitiesClose(ByRef qHandle As %Binary) 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)
Selects entityValue As %String, relatedValue As %String, proximity As %Integer
Searches for entities related to a given or similar string
query GetRelatedEntities(domainId As %Integer, entityId As %Integer)
Selects entityId As %Integer, entityValue As %String, proximity As %Integer

Inherited Members

Inherited Properties

Inherited Methods

FeedbackOpens in a new tab