persistent class %BI.FileTemplates
extends %Persistent
• property ChartHeight
as %Integer;
• property ChartLeft
as %Integer;
• property ChartSheetIndex
as %Integer;
• property ChartShow
as %Boolean;
• property ChartTop
as %Integer;
• property ChartWidth
as %Integer;
• property DataSheetIndex
as %Integer;
• property Description
as %String(MAXLEN=5000,TRUNCATE=1);
• property ExcelOmitCol
as %String(TRUNCATE=1);
• property ExcelStartLine
as %SmallInt;
• property ExcellExportHeader
as %Boolean;
• property FileName
as %String(MAXLEN=5000,TRUNCATE=1);
• property IsActive
as %Boolean;
• property TemplateName
as %String(MAXLEN=5000,TRUNCATE=1);
• property TemplateType
as %String(DISPLAYLIST=",MS Excel,MS Word,HTML",TRUNCATE=1,VALUELIST=",0,1,2");
• query AllTemplates()
SQL Query
:
SELECT ID,TemplateName,FileName,%External(TemplateType),IsActive FROM FileTemplates
• query byType(iType As %SmallInt)
SQL Query
:
SELECT ID,TemplateName FROM FileTemplates
WHERE (TemplateType = :iType) AND (IsActive=1)
