This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Home > Class Reference > %SYS namespace > %BI.FileTemplates

%BI.FileTemplates

persistent class %BI.FileTemplates extends %Library.Persistent

SQL Table Name: %BI.FileTemplates

Property Inventory (Including Private)

Properties (Including Private)

property ChartHeight as %Integer;
Property methods: ChartHeightDisplayToLogical(), ChartHeightGet(), ChartHeightGetStored(), ChartHeightIsValid(), ChartHeightLogicalToDisplay(), ChartHeightNormalize(), ChartHeightSet()
property ChartLeft as %Integer;
Property methods: ChartLeftDisplayToLogical(), ChartLeftGet(), ChartLeftGetStored(), ChartLeftIsValid(), ChartLeftLogicalToDisplay(), ChartLeftNormalize(), ChartLeftSet()
property ChartSheetIndex as %Integer;
Property methods: ChartSheetIndexDisplayToLogical(), ChartSheetIndexGet(), ChartSheetIndexGetStored(), ChartSheetIndexIsValid(), ChartSheetIndexLogicalToDisplay(), ChartSheetIndexNormalize(), ChartSheetIndexSet()
property ChartShow as %Boolean;
Property methods: ChartShowDisplayToLogical(), ChartShowGet(), ChartShowGetStored(), ChartShowIsValid(), ChartShowLogicalToDisplay(), ChartShowNormalize(), ChartShowSet()
property ChartTop as %Integer;
Property methods: ChartTopDisplayToLogical(), ChartTopGet(), ChartTopGetStored(), ChartTopIsValid(), ChartTopLogicalToDisplay(), ChartTopNormalize(), ChartTopSet()
property ChartWidth as %Integer;
Property methods: ChartWidthDisplayToLogical(), ChartWidthGet(), ChartWidthGetStored(), ChartWidthIsValid(), ChartWidthLogicalToDisplay(), ChartWidthNormalize(), ChartWidthSet()
property DataSheetIndex as %Integer;
Property methods: DataSheetIndexDisplayToLogical(), DataSheetIndexGet(), DataSheetIndexGetStored(), DataSheetIndexIsValid(), DataSheetIndexLogicalToDisplay(), DataSheetIndexNormalize(), DataSheetIndexSet()
property Description as %String (MAXLEN = 5000, TRUNCATE = 1);
Property methods: DescriptionDisplayToLogical(), DescriptionGet(), DescriptionGetStored(), DescriptionIsValid(), DescriptionLogicalToDisplay(), DescriptionLogicalToOdbc(), DescriptionNormalize(), DescriptionSet()
property ExcelOmitCol as %String (TRUNCATE = 1);
Property methods: ExcelOmitColDisplayToLogical(), ExcelOmitColGet(), ExcelOmitColGetStored(), ExcelOmitColIsValid(), ExcelOmitColLogicalToDisplay(), ExcelOmitColLogicalToOdbc(), ExcelOmitColNormalize(), ExcelOmitColSet()
property ExcelStartLine as %SmallInt;
Property methods: ExcelStartLineDisplayToLogical(), ExcelStartLineGet(), ExcelStartLineGetStored(), ExcelStartLineIsValid(), ExcelStartLineLogicalToDisplay(), ExcelStartLineNormalize(), ExcelStartLineSet()
property ExcellExportHeader as %Boolean;
Property methods: ExcellExportHeaderDisplayToLogical(), ExcellExportHeaderGet(), ExcellExportHeaderGetStored(), ExcellExportHeaderIsValid(), ExcellExportHeaderLogicalToDisplay(), ExcellExportHeaderNormalize(), ExcellExportHeaderSet()
property FileName as %String (MAXLEN = 5000, TRUNCATE = 1);
Property methods: FileNameDisplayToLogical(), FileNameGet(), FileNameGetStored(), FileNameIsValid(), FileNameLogicalToDisplay(), FileNameLogicalToOdbc(), FileNameNormalize(), FileNameSet()
property IsActive as %Boolean;
Property methods: IsActiveDisplayToLogical(), IsActiveGet(), IsActiveGetStored(), IsActiveIsValid(), IsActiveLogicalToDisplay(), IsActiveNormalize(), IsActiveSet()
property TemplateName as %String (MAXLEN = 5000, TRUNCATE = 1);
Property methods: TemplateNameDisplayToLogical(), TemplateNameGet(), TemplateNameGetStored(), TemplateNameIsValid(), TemplateNameLogicalToDisplay(), TemplateNameLogicalToOdbc(), TemplateNameNormalize(), TemplateNameSet()
property TemplateType as %String (DISPLAYLIST = ",MS Excel,MS Word,HTML", TRUNCATE = 1, VALUELIST = ",0,1,2");
Property methods: TemplateTypeDisplayToLogical(), TemplateTypeGet(), TemplateTypeGetStored(), TemplateTypeIsValid(), TemplateTypeLogicalToDisplay(), TemplateTypeLogicalToOdbc(), TemplateTypeNormalize(), TemplateTypeSet()

Queries

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)

Inherited Members

Inherited Methods (Including Private)

Storage

Storage Model: CacheStorage (%BI.FileTemplates)

^BI.FileTemplatesD(ID)
=
%%CLASSNAME
FileName
IsActive
TemplateName
TemplateType
Description
ExcelOmitCol
ExcelStartLine
ExcellExportHeader
ChartHeight
ChartLeft
ChartSheetIndex
ChartTop
ChartWidth
DataSheetIndex
ChartShow
Feedback