-
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
FileMaker, Salesforce Integration - Get the Best of Both the Worlds
First things first, why do we need the integration at all? Direct integration between FileMaker and Salesforce allows developers to use the best capabilities of…
How to Make Communities Faster? What are the Required Tools for This?
As businesses and organizations expand, the need to manage and maintain multiple systems becomes increasingly necessary. Often, data needs to be shared across systems, and…
Drive Financial Growth with Sage Intacct Consulting Benefits
Businesses must keep ahead of the curve in an ever-changing business climate by using the appropriate solutions. Sage Intacct, a financial management tool designed to…
Popular Salesforce Videos
How to Elevate Engagement with Salesforce Experience Cloud?
Salesforce Experience Cloud helps companies create personalized portals for customers to find answers, collaborate, and be part of a community. In this video, ENWAY will…
MailChimp Salesforce Integration
The MailChimp and Salesforce integration allow you to start creating email campaigns from the leads and contacts in your Salesforce CRM. With the integration, it becomes easy to create list segmentation…
How to use Einstein Engagement Scoring in Salesforce Marketing Cloud
Cameron Robert shows how to gain actionable insights from the Einstein Engagement Scoring Dashboard in Salesforce Marketing Cloud, and talks through a few activity ideas…
