-
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
User Agent Flow in Salesforce | The Developer Guide
User Agent Flow (Mobile App Integration) A simple flow for clients that don't need to include global secrets (such as distributed apps) but can be…
Magento 2 Integration With Salesforce: Unleashing The Power Of eCommerce
Are you struggling to take your online store's performance to new heights? Look no further! In today's digital age, seamless integration is the key to…
Want to Hire the Best Salesforce Consultants? Here’s Everything You Should Know!
There’s hardly anyone in the business industry who is unaware of Salesforce. We all know Salesforce to be the no. 1 CRM in the world…
Popular Salesforce Videos
Accenture + Salesforce: Making an Impact
Our people and communities are important connection points for support. Hear more from our Salesforce professionals. Check out this video to learn everything you need…
How To Use Data Loader In Salesforce - Learn Salesforce Series By Algoworks
Learn how to use Data Loader in Salesforce. In this video, the following points will be covered - 1. Introduction Here you will get a…
Pardot Marketing Automation Tools Overview Webinar
Are you looking to take your Salesforce Marketing Automation to the next level? Learn how to build successful lead nurturing campaigns that empower your sales team…
