-
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
Tips for Customizing Web-to-Lead Forms in Salesforce
Salesforce Web-to-Lead is the default way to import Leads into Salesforce from a web form. The way it works is simple: you select the fields…
Best SMS App for Salesforce: Features and Benefits
In today’s time, companies are supposed to keep their customers updated with every little bit of information. They must thrive on quick, effective, and seamless…
Test Classes In Apex Salesforce | The Developer Guide
Best Practices of Test Class in Salesforce @TestVisible - To access private member in Test Class Test.LoadData - Creating test data without code System.RunAs -…
Popular Salesforce Videos
Salesforce - Sage ERP Integration
Salesforce Integration with Sage ERP (SageX3 / Sage100 / Sage300) delivers seamless, real-time, bi-directional integration that plays a pivotal role in unlocking the potential of…
Salesforce to Twilio Integration Using MuleSoft | SFDC
Take a look at how Twilio integration with Salesforce is done using MuleSoft. This tutorial will cover the following points - 1. Introduction Learn how…
Tips to Crack the Salesforce Administrator Certification Exam in One Go
Do you want to become Salesforce administrator certified? So in this video Shrey has shared the important topics to crack the Salesforce Administrator Exam. Watch…
