-
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 for Agent Productivity: Boosting Sales in the Insurance Sector
The insurance sector is rapidly evolving due to changes in customer expectations and substantial technological advancements. Insurance agents have to face pressure to deliver faster,…
Best Practices To Be Followed In Salesforce Lightning Web Components
Introduction Lightning Web Components (LWC) is a modern Salesforce development method that uses open web standards (such as standard JavaScript and HTML), allowing developers who…
Ultimate Guide to Sales Quotes in Salesforce in 2024
Automating sales quotes in Salesforce is usually put on the back burner by sales reps. But will a change of this perspective influence the sales…
Popular Salesforce Videos
Manage Packages & Post Installation Script | Salesforce Managed Packages
This video will give you a brief overview of Managed Packages and Unmanaged Packages in Salesforce. You will get a quick glance at how to…
The New Salesforce Nonprofit Cloud: How To Upgrade
The new Salesforce Nonprofit Cloud is an innovative platform tailored specifically to enhance the operations and effectiveness of nonprofit organizations. This advanced solution provides a…
Increase ROI by Investing in People | Make Earth Your Business
The video discusses the benefits of businesses that invest in and believe in their employees, customers, and communities. Investing in employee training and upskilling programs…
