-
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
What is Nonprofit Success Pack and Tips To Make The Best Out Of It | Salesforce
Every Nonprofit organization needs to manage its data like donor's information, volunteers, accounts, emails, etc in one place for it to run seamlessly. The Nonprofit…
Passing URL parameters to Apex controller in a Lightning components
The following example helps you understand how to pass parameters from URL to components. In AURA , it is made easy to pass the parameters…
Is Salesforce a Lucrative Career Path?
Salesforce is "the world's #1 customer relationship management (CRM)," according to the website of the company. Their software is aimed to help organizations expand by…
Popular Salesforce Videos
All About Salesforce Web Chat
Salesforce webchat help customer interacts with the support team. It also improves the support experience for customers. It is very easy to set up the…
How to Create Opportunity Teams | Salesforce Tutorial
Want to give all the people who help out on your opportunities easy access to the opportunity record in Salesforce? Or maybe you've got an…
How to import data from Sage ERP to Salesforce - Part 1
Greytrix offers GUMU™ integration for Salesforce with Sage ERP systems - a best-of-breed solution for organizations to enhance their customer interaction. With Salesforce and Sage…
