SELECT Id, vlocity_cmt__EntityFilterId__c,vlocity_cmt__EntityFilterId__r.Name,vlocity_cmt__Index__c,vlocity_cmt__Type__c,vlocity_cmt__FieldName__c,vlocity_cmt__Operator__c,vlocity_cmt__Value__c from vlocity_cmt__EntityFilterCondition__c where vlocity_cmt__EntityFilterId__c in (select vlocity_cmt__EntityFilterId__c from vlocity_cmt__RuleAction__c ) order by vlocity_cmt__EntityFilterId__r.Id desc
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter