-
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
Latest Salesforce Commerce Cloud Feature: Lightning Order Management to Enhance the Order Management Process
If you are in the process of managing end-to-end order management in e-commerce or a product company, you would agree that it is the most…
Key Salesforce Benefits for Healthcare
During the peak of COVID-19, the importance of a streamlined workflow that would make the most efficient use of healthcare resources such as medicines, equipment,…
No Code Clearbit and Salesforce Integration
Clearbit is a consumer contact marketing data engine. It assists businesses in expanding by delivering solutions that enable them to better understand their clients, discover…
Popular Salesforce Videos
Which Salesforce Certifications are Really Important?
If you really want to know which Salesforce certifications are really important then this video is for you. If you have any doubts or concerns,…
How to create an App in Lighting Experience?
Salesforce is the trusted cloud when it comes to privacy and we are sure the Lightning will strike here thrice. As Salesforce is expanding, new…
Dreamforce 2020: Dreamforce to You | Salesforce
Caylin walks us through what's in store for Salesforce's Dreamforce 2020 - Dreamforce to You! It's a month (or two?) long DF this year, so…
