Example:
To get the count of users from sales force where the email address of the user doesn't belongs some specific domain, let's say 'abcd'
Here is the SOQL
Select count() from User where NOT email like '%@abcd.com'
To get the count of users from sales force where the email address of the user doesn't belongs some specific domain, let's say 'abcd'
Here is the SOQL
Select count() from User where NOT email like '%@abcd.com'
"Hi,
ReplyDeleteI like your blog very much! It is found me so interesting and informative... Thanks very much for sharing this amazing information over here…"
PIC Scheme Singapore
This SOQL "NOT LIKE" keyword tutorial is very helpful for Salesforce developers! The explanation of how to use the NOT LIKE operator for pattern matching in SOQL queries is very practical. I appreciated the wildcard character examples. Understanding SOQL query optimization is essential for building efficient Salesforce applications. For those wanting to combine Salesforce skills with AI technologies, AI training in Electronic City with placement can help you apply these concepts in real-world projects. Thanks for sharing this helpful Salesforce guide!
ReplyDelete