persistent class %BI.QueryDrillDown
extends %Persistent
property AdditionalCondition
as %String(TRUNCATE=1);
property IsActive
as %Boolean;
property LinkField
as %String(TRUNCATE=1);
property MenuDesc
as %String(TRUNCATE=1);
relationship QueryCom
as %BI.QueryCom [ Inverse = QueryDrillDown,Cardinality = parent ];
property TargetQueryCom
as %String(TRUNCATE=1);
property TargetQueryComName
as %String(TRUNCATE=1) [ Calculated,SqlFieldName = TargetQueryComName ];
query byQueryCom(comid As %String)
SQL Query
:
SELECT ID,MenuDesc,TargetQueryCom,LinkField,AdditionalCondition,IsActive,TargetQueryComName
FROM QueryDrillDown
WHERE (QueryCom = :comid)