-
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
Small business’s customer service dilemma: Salesforce Desk.com or Service Cloud Essentials?
Browsing through Salesforce offerings, small businesses may feel as if they were at a huge, noisy, exotic market somewhere in Asia: there’s so much to…
Salesforce: How to detect "Impersonation" through code?
Hello Guys, I got a business requirement to implement for one of my client, they wanted me to prevent their application's access for impersonated user.…
Unboxing Salesforce Knowledge Rest APIs
SF knowledge rest APIs come in 4 different flavours (Types) based on the polymorphic nature of the data model and each different type (as below)…
Popular Salesforce Videos
Develop Lightning Web Components Faster with Local Development Server | Developer Quick Takes
The Local Development Server is a Salesforce CLI plug-in that configures and runs a Lightning Web Components-enabled server on your computer. You can develop Lightning…
Event & Task List - Salesforce Classic vs Salesforce Lightning
Event & Task List - Salesforce Classic vs Salesforce Lightning Video demonstrated the Event & Task List Salesforce Event List in Salesforce Classic Task List…
Creation Of Validation Rules And Verifying Them In Salesforce
Learn how to create and verify validation rules in Salesforce. This video will cover the following points - 1. Introduction Get a brief introduction about…
