-
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 Pardot vs Hubspot - Complete Breakdown
Pardot Vs Hubspot – An end-to-end comparison of Features, Pricing & Integrations First things first. Whether you opt for Pardot or Hubspot, it’s all about…
Salesforce to Salesforce Integration Using REST API
After learning the REST API, it's always good to do some practice to make the concept more clear. In this Blog, we will Integrate Two…
Diverse Platforms for Salesforce Mobile App Development Tools
In the age where 95% of the people own mobile devices and use cloud services, having a mobile application for every business has become more…
Popular Salesforce Videos
Salesforce Guide to Sharing Architecture
The Salesforce sharing model is an essential element in your organization's ability to provide secure application data access. Therefore, it's crucial to architect your sharing…
Features of Salesforce Industries (Vlocity)
There are many features of Salesforce Industries that make it a one-stop solution for businesses. Salesforce Industries or Vlocity offers Omnichannel processes with lightning Web,…
Salesforce Multi-factor Authentication/Two-factor Authentication End User Training Video
Watch this video to learn all about Salesforce Multi-factor Authentication/Two-factor Authentication. This is a training video. Watch and learn.