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