persistent class %BI.Condition
extends %Persistent
query CompoundConditions(Class)
Selects
ID, Condition, ShortName
SQL Query
:
Select ID,Condition,ShortName
from %BI.Condition
where Class = :Class and Type = 'C'
index (ShortName on Class,Category,ShortName);
index (ShortNameS on Class,Category,ShortName:SqlString);