-
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 Slack Integration and Configuration: Our Tried and Trusted Approaches
Both Salesforce and Slack are powerful business technologies on their own. Salesforce is the global No. 1 CRM, integration, and analytics platform. Slack is the…
Passing the Salesforce AI Specialist Certification with Dumpsforsure – Your Complete Success Guide
Introduction : The Salesforce AI Specialist certification has quickly become one of the most valuable credentials for professionals working in artificial intelligence and CRM technology.…
Salesforce Summer '24 Release: Features Overview
Every Salesforce release introduces many updates and new features, enhancing the platform's efficiency and flexibility. These improvements benefit business users, developers, and administrators alike, enabling…
Popular Salesforce Videos
Translate/Rename Custom Field Labels in Salesforce
Watch the short video instruction of how you can translate or rename custom field labels, fieldsets, buttons, etc. that come with installed managed packages in…
How to Become a Salesforce Admin | 6-step Guide
Salesforce administrators are the backbone of any company that uses Salesforce. They are responsible for maintaining the Salesforce platform to ensure it meets the needs…
Design Patterns and Best Practices to Build Reusable Lightning Web Components | Salesforce Tutorial
LWC Best Practices & Design Pattern Component Architecture and Composition Styling Reusable components Sharing components between LWC and LWC OSS Packaging LWC and LWC OSS…
