persistent class %BI.Query
extends %Persistent, %XML.Adaptor
property descr
as %String(MAXLEN=10000,TRUNCATE=1);
property fldr
as %String(TRUNCATE=1);
property nm
as %String(TRUNCATE=1);
property qry
as %String(MAXLEN=10000,TRUNCATE=1);
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