persistent class %BI.Planner
extends %Persistent, %XML.Adaptor
• property ClsName
as %String(TRUNCATE=1);
• property Fldr
as %String(TRUNCATE=1);
• property Flt
as %String(TRUNCATE=1);
• property QryLine
as array of %String(TRUNCATE=1);
• property SjArea
as %Integer;
• property VName
as %String(MAXLEN=200,TRUNCATE=1) [ Required ];
• classmethod createQuery(tbody)
• classmethod deletePlanner(id)
• classmethod getQuery(id)
• classmethod loadDataJS(id)
• classmethod loadDimJS()
• classmethod loadValJS(dimID, dimName, condBegin)
• classmethod saveDataJS(plannerId, vName, foldID, query, tbody)
• query AllPlanner()
SQL Query
:
SELECT %ID,VName,Fldr FROM Planner
ORDER BY VName
• query FolderPlanner(folder)
SQL Query
:
SELECT %ID,VName FROM Planner
WHERE fldr=:folder
ORDER BY VName
