This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see How to Migrate to InterSystems IRIS, available on the WRC Distributions page (login required).

%BI.Query

persistent class %BI.Query extends %Library.Persistent, %XML.Adaptor

SQL Table Name: %BI.Query

Property Inventory (Including Private)

Properties

property descr as %String (MAXLEN = 10000, TRUNCATE = 1);
Property methods: descrDisplayToLogical(), descrGet(), descrGetStored(), descrIsValid(), descrLogicalToDisplay(), descrLogicalToOdbc(), descrNormalize(), descrSet()
property fldr as %String (TRUNCATE = 1);
Property methods: fldrDisplayToLogical(), fldrGet(), fldrGetStored(), fldrIsValid(), fldrLogicalToDisplay(), fldrLogicalToOdbc(), fldrNormalize(), fldrSet()
property nm as %String (TRUNCATE = 1);
Property methods: nmDisplayToLogical(), nmGet(), nmGetStored(), nmIsValid(), nmLogicalToDisplay(), nmLogicalToOdbc(), nmNormalize(), nmSet()
property qry as %String (MAXLEN = 10000, TRUNCATE = 1);
Property methods: qryDisplayToLogical(), qryGet(), qryGetStored(), qryIsValid(), qryLogicalToDisplay(), qryLogicalToOdbc(), qryNormalize(), qrySet()

Queries

query ListAll()
SQL Query:
SELECT ID,nm,fldr FROM %BI.Query ORDER BY nm
query ListFolder(folder)
SQL Query:
SELECT ID,nm FROM %BI.Query WHERE (fldr = :folder) ORDER BY nm

Indices

index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods (Including Private)

Storage

Storage Model: CacheStorage (%BI.Query)

^BI.QueryD(ID)
=
%%CLASSNAME
Folder
Query
QueryName
LastAccessed
Accessed
Descr
User
Users
acc
descr
fldr
nm
qry
users
Feedback