This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Home > Class Reference > %SYS namespace > %BI.Query

%BI.Query

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

SQL Table Name: %BI.Query

Property Inventory (Including Private)

Properties (Including Private)

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

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