Confirm Rules not include ';'
Fri Apr 07 2023 16:11:16 GMT+0000 (Coordinated Universal Time)
Saved by
@atsigkas
select id, vlocity_cmt__Value__c,vlocity_cmt__EntityFilterId__c from vlocity_cmt__EntityFilterCondition__c where vlocity_cmt__EntityFilterId__c in (select vlocity_cmt__EntityFilterId__c from vlocity_cmt__RuleAction__c where (vlocity_cmt__ProductRelationshipId__r.vlocity_cmt__RelationshipType__c = 'Auto-Remove' or vlocity_cmt__ProductRelationshipId__r.vlocity_cmt__RelationshipType__c = 'Auto-Add') and vlocity_cmt__ProductRelationshipId__r.vlocity_cmt__Product2Id__r.name like 'Caldaia%')
order by vlocity_cmt__EntityFilterId__c desc
content_copyCOPY
Comments