This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

%BI.QueryDrillDown

persistent class %BI.QueryDrillDown extends %Library.Persistent

SQL Table Name: %BI.QueryDrillDown

Property Inventory (Including Private)

Method Inventory (Including Private)

Properties

property AdditionalCondition as %String (TRUNCATE = 1);
Property methods: AdditionalConditionDisplayToLogical(), AdditionalConditionGet(), AdditionalConditionGetStored(), AdditionalConditionIsValid(), AdditionalConditionLogicalToDisplay(), AdditionalConditionLogicalToOdbc(), AdditionalConditionNormalize(), AdditionalConditionSet()
property IsActive as %Boolean;
Property methods: IsActiveDisplayToLogical(), IsActiveGet(), IsActiveGetStored(), IsActiveIsValid(), IsActiveLogicalToDisplay(), IsActiveNormalize(), IsActiveSet()
property LinkField as %String (TRUNCATE = 1);
Property methods: LinkFieldDisplayToLogical(), LinkFieldGet(), LinkFieldGetStored(), LinkFieldIsValid(), LinkFieldLogicalToDisplay(), LinkFieldLogicalToOdbc(), LinkFieldNormalize(), LinkFieldSet()
Property methods: MenuDescDisplayToLogical(), MenuDescGet(), MenuDescGetStored(), MenuDescIsValid(), MenuDescLogicalToDisplay(), MenuDescLogicalToOdbc(), MenuDescNormalize(), MenuDescSet()
relationship QueryCom as %BI.QueryCom [ Required , Inverse = QueryDrillDown , Cardinality = parent ];
Property methods: QueryComCheck(), QueryComDelete(), QueryComGet(), QueryComGetObject(), QueryComGetObjectId(), QueryComGetStored(), QueryComGetSwizzled(), QueryComIsValid(), QueryComNewObject(), QueryComOnDelete(), QueryComRClose(), QueryComRExec(), QueryComRFetch(), QueryComRelate(), QueryComSQLCompute(), QueryComSet(), QueryComSetObject(), QueryComSetObjectId(), QueryComUnRelate(), QueryComUnSwizzle()
property TargetQueryCom as %String (TRUNCATE = 1);
Property methods: TargetQueryComDisplayToLogical(), TargetQueryComGet(), TargetQueryComGetStored(), TargetQueryComIsValid(), TargetQueryComLogicalToDisplay(), TargetQueryComLogicalToOdbc(), TargetQueryComNameCompute(), TargetQueryComNameDisplayToLogical(), TargetQueryComNameGet(), TargetQueryComNameIsValid(), TargetQueryComNameLogicalToDisplay(), TargetQueryComNameLogicalToOdbc(), TargetQueryComNameNormalize(), TargetQueryComNameSQLCompute(), TargetQueryComNormalize(), TargetQueryComSet()
property TargetQueryComName as %String (TRUNCATE = 1) [ Calculated ];
Property methods: TargetQueryComNameCompute(), TargetQueryComNameDisplayToLogical(), TargetQueryComNameGet(), TargetQueryComNameIsValid(), TargetQueryComNameLogicalToDisplay(), TargetQueryComNameLogicalToOdbc(), TargetQueryComNameNormalize(), TargetQueryComNameSQLCompute()

Methods

method TargetQueryComNameGet() as %String

Queries

query byQueryCom(comid As %String)
SQL Query:
SELECT ID,MenuDesc,TargetQueryCom,LinkField,AdditionalCondition,IsActive,TargetQueryComName FROM QueryDrillDown WHERE (QueryCom = :comid)

Indices

index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods (Including Private)

Storage

Storage Model: CacheStorage (%BI.QueryDrillDown)

{%%PARENT}("DD")(ID,"X")
=
%%CLASSNAME

Storage Model: CacheStorage (%BI.QueryDrillDown)

{%%PARENT}("DD")(ID)
=
IsActive
LinkField
MenuDesc
TargetQueryCom
AdditionalCondition
Feedback