-
Filtering results with NOT LIKE in Salesforce?
Hi everyone,
I have to query task object to get the rows with subject not starting with 'Email' .I have tried the given query. But it is not working . Please suggest.
select status, subject, whatId from task where subject != 'Email:%'
also, there is nothing like NOT LIKE that I can use.
Thanks in advance
-
1 Reply
-
Hi kumar,
you can try this query
select status, subject, whatId from task where NOT subject LIKE 'Email:%'
Log In to reply.
Popular Salesforce Blogs
Salesforce Rest API Integration with Neverbounce
Let’s learn how you can integrate our Salesforce org with Neverbounce and get the status of the emails of Contact records. First, you need to…
What are Auto-Launched Flows? | All You Need to Know
What are Auto-launched Flows? A certain event, such as the creation or updating of a record or the receiving of a platform event, can automatically…
9 Salesforce Development Best Practices
Learning to code might be dreadful for a few of us, but all of us would like to tweak something the way we wish. Salesforce…
Popular Salesforce Videos
Get Started with Salesforce Elevate
Salesforce is a powerful tool to analyze your past fundraising, and monitor your ongoing efforts. In this webinar, we'll start with the fundamentals -- understanding…
Salesforce Sales Cloud Basics
This short video shows how easy to create & manage leads and to convert it to opportunity, contacts & accounts using Salesforce Sales Cloud. Please…
What is the Difference Between Object and Database in Salesforce?
Salesforce Object: Salesforce Object are database table which give permission to store data that is specific to organization. Salesforce Database: The organized collection of object…
