persistent class %BI.StoredProc
extends %Persistent, %XML.Adaptor
• property cls
as %String(TRUNCATE=1);
• property descr
as %String(MAXLEN=10000,TRUNCATE=1);
• property fldr
as %String(TRUNCATE=1);
• property help
as %String(TRUNCATE=1);
• property nm
as %String(TRUNCATE=1);
• property param
as %String(MAXLEN=10000,TRUNCATE=1);
• property proc
as %String(TRUNCATE=1);
• query ListByFldr(fldr As %String)
SQL Query
:
SELECT %ID,nm FROM StoredProc
WHERE (fldr = :fldr)
ORDER BY nm
• query ListFolder(folder)
SQL Query
:
SELECT ID,nm
FROM %BI.StoredProc
WHERE (fldr = :folder)
ORDER BY nm
• query ListProc()
SQL Query
:
SELECT ID,nm,fldr
FROM %BI.StoredProc
ORDER BY nm
• index (Name on nm:Exact);
