%BI.FileTemplates
persistent class %BI.FileTemplates extends %Library.Persistent
SQL Table Name: %BI.FileTemplates
Property Inventory
- ChartHeight
- ChartLeft
- ChartSheetIndex
- ChartShow
- ChartTop
- ChartWidth
- DataSheetIndex
- Description
- ExcelOmitCol
- ExcelStartLine
- ExcellExportHeader
- FileName
- IsActive
- TemplateName
- TemplateType
Properties
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
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)
SELECT ID,TemplateName FROM FileTemplates WHERE (TemplateType = :iType) AND (IsActive=1)
Indexes
index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %BMEBuilt()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %InsertBatch()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %KillExtentData()
- %LoadFromMemory()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDetermineClass()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PhysicalAddress()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SaveIndices()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
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
|