-
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 Lightning Dominates Dreamforce 2017 — Here are the Six Takeaways!
In the customer dominated era, CRM system plays an integral role in maintaining and accelerating the growth of a business. This is really difficult for…
Get Picklist Values in Salesforce Lightning Component From a Common Apex Function
See below the code example to get Picklist Values in Salesforce Lightning Component from a Common Apex Function: CommonPicklist.cmp <aura:component controller="CommonPicklistController"> <aura:attribute name="ObjectName" type="String" default="Opportunity"…
Custom Metadata Types: Your Recipe for API Key Security
Imagine we are running a top-secret sandwich joint, and we've got the most delicious secret sauce recipe that's known to humankind. Now, we don’t want…
Popular Salesforce Videos
Slack API Integration for Salesforce Marketing Cloud
Connect Salesforce Marketing Cloud and Slack the way you want. Watch this video to learn all about Slack API Integration for Salesforce Marketing Cloud. If…
Send WhatsApp Messages from Salesforce Marketing Cloud
One of the longest-anticipated integrations was recently revealed by Salesforce: WhatsApp as a platform to send messages using the marketing cloud. Brands today have many…
Learn How To Crack Salesforce Interview In The First Attempt | Salesforce Salaries
This MindMajix video on How To Crack Salesforce Interview In First Attempt video for both freshers and experienced will help you to learn the key…
