Skip to main content

%BI.Query

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

SQL Table Name: %BI.Query

Property Inventory

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

Indexes

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

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (%BI.Query)

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