-
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
Leveraging Salesforce’s Complimentary Data Cloud and Tableau Licenses
In the ever-evolving landscape of business, access to valuable data insights and powerful analytics tools is essential for sustainable growth. Salesforce, a leader in customer…
How to add Visualforce Web tabs in Salesforce1 mobile?
We all know that the Web tab is not working inside the Salesforce1 Mobile Navigation Bar. Therefore, we need to create a Visualforce page. I…
Modernize your Business with Salesforce hasten Applications
Salesforce is the world’s largest customer relationship management(CRM) tool provider which allows companies to connect with their customers in a completely new way. The CRM…
Popular Salesforce Videos
How to Translate/Override Custom Labels in Salesforce
In this video, you can see how to translate or override custom labels that come with installed managed packages in Salesforce.
Insert Data in Salesforce Using Standard Controller
Standard controllers provides ability to access and interact with structured business data contained in records displays in the proper user interface. Standard controller tasks: controlling…
Hello (Salesforce) World - An introduction to Tableau Developer
Hello, Salesforce world! Curious about Tableau (the newest member of the Salesforce family), our developer platform and suite of developer tools available? Whether you are…
