Hi,

I'm new to SOQL. I'm working on Lookup Rollup Summaries and on Relationship Criteria, I would to put condition where
A__c contains Apple
AND
B__c doesn't contain Bird

When I tried on code below, its doens't work
A__c LIKE '%Apple%' AND  
NOT(B__c LIKE '%Bird%')

But when I tried with one condition for each of them, its works perfectly.

Could you please help what have I done wrong please as I'm really new to SOQL

thank you

Hi,

I'm new to SOQL. I'm working on Lookup Rollup Summaries and on Relationship Criteria, I would to put condition where
A__c contains Apple
AND
B__c doesn't contain Bird

When I tried on code below, its doens't work
A__c LIKE '%Apple%' AND  
NOT(B__c LIKE '%Bird%')

But when I tried with one condition for each of them, its works perfectly.

Could you please help what have I done wrong please as I'm really new to SOQL

thank you