Skip to main content

%BI.CodeTable

persistent class %BI.CodeTable extends %Library.Persistent

SQL Table Name: %BI.CodeTable

Property Inventory

Properties

property Code as %String (TRUNCATE = 1) [ Required ];
Property methods: CodeDisplayToLogical(), CodeGet(), CodeGetStored(), CodeIsValid(), CodeLogicalToDisplay(), CodeLogicalToOdbc(), CodeNormalize(), CodeSet()
property Data as %List;
Property methods: DataGet(), DataGetStored(), DataIsValid(), DataLogicalToOdbc(), DataOdbcToLogical(), DataSet()
property Type as %String (TRUNCATE = 1) [ Required ];
Property methods: TypeDisplayToLogical(), TypeGet(), TypeGetStored(), TypeIsValid(), TypeLogicalToDisplay(), TypeLogicalToOdbc(), TypeNormalize(), TypeSet()

Queries

query ByType(Type As %String)
SQL Query:
SELECT Code,Data FROM CodeTable WHERE (Type = :Type) ORDER BY Code
query TypeAll()
SQL Query:
SELECT %ID,Type FROM CodeTable GROUP BY Type

Indexes

index (MainIndex on Type,Code) [IdKey, Type = key, Unique];
Index methods: MainIndexCheck(), MainIndexDelete(), MainIndexExists(), MainIndexOpen(), MainIndexSQLCheckUnique(), MainIndexSQLExists(), MainIndexSQLFindPKeyByConstraint(), MainIndexSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (%BI.CodeTable)

^BI.CodeTableD(ID,"X")
=
%%CLASSNAME

Storage Model: CacheStorage (%BI.CodeTable)

^BI.CodeTableD(ID,n)
=
Data(n)
FeedbackOpens in a new tab