-
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
Why Do You Have to Learn Salesforce & How Will it Assist You in Your Career Growth in 2021
First of all let’s understand, What Salesforce Is? Salesforce is currently the world’s ranked #1 Customer Relationship Management(CRM) solutions provider, according to Forbes it controls…
Syncing Articles from Zendesk Knowledge Base to Salesforce Knowledge – A Success Story
Customers need excellent support with minimal human interaction. That’s why they prefer self-service. And to keep customers hooked to your product, you need to give…
Transforming Customer Experience: Why Businesses Need a Salesforce Customer Portal in 2025
Customer experience (CX) is the actual competitive advantage in 2025. Customers demand immediate service, customized service, and convenience based on digital-first at all touchpoints. These…
Popular Salesforce Videos
Salesforce Admin Certification Questions and Explained Answers with References to Trailblazers
A Salesforce Admin Certification is the highest form of recognition a Salesforce Administrator can achieve; it demonstrates expertise in the field as well as a…
Salesforce Connections 2018 Keynote - Ch. 2: Ticketmaster Is A Trailblazer
Salesforce Connections 2018 Keynote – Ch. 1: Corporate Positioning Salesforce Connections 2018 Keynote – Ch. 2: Ticketmaster Is A Trailblazer Salesforce Connections 2018 Keynote –…
Salesforce 101 for Salespeople
In this video, Oliver Sholder breaks down Salesforce 101 for us. He covers everything from what Salesforce is and does, to how it can benefit…
