-
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
Learn All About Visualforce in Salesforce
What is Visualforce? Visualforce is a framework that developers can use to create sophisticated custom user interfaces that can be hosted natively on the Lightning…
7 Outstanding Ways to Use Salesforce for Customer Retention
In this modern era, customers have become more demanding than ever. Especially after the global pandemic, customers were frustrated because of severe financial constraints, which…
Salesforce Announced The End of Life of Permissions on Profiles | The Developer Guide
The time has finally arrived when Salesforce recently announced that the Spring '26 release would mark the end of life (EOL) for permissions on profiles.…
Popular Salesforce Videos
Introduction to Creating and Using Salesforce Reports
Every Salesforce user can benefit from working with Salesforce Reports. We often say that one of the best Salesforce features is that "...even mere mortals…
Salesforce Guide to Sharing Architecture
The Salesforce sharing model is an essential element in your organization's ability to provide secure application data access. Therefore, it's crucial to architect your sharing…
Login Flow In Salesforce
You can use a login flow to customize the login experience and integrate business processes with Salesforce authentication. Common use cases include collecting and updating…