LIKE Operator In Salesforce

The LIKE operator in SOQL and SOSL is quite similar to the LIKE operator in SQL; it provides a mechanism for matching partial text strings and includes support for wildcards.

Suppose we need to delete some test records of Account object, all test records are created having account name is test. Account name may "testasish" or "accounttest", how can we get those record by Soql query ?
For this propose LIKE operator is useful.

For example
List<Account> listOfAccounts;
listOfAccounts = [SELECT id, Name
FROM Account
WHERE Name LIKE '%test%'];
This query matches both testasish,accounttest, and test.

Use Cases Of LIKE Operator

The % and _ wildcards are supported for the LIKE operator.
The % wildcard matches zero or more characters.
The _ wildcard matches exactly one character.
The text string in the specified value must be enclosed in single quotes.
The LIKE operator is supported for string fields only.
The LIKE operator performs a case-insensitive match, unlike the case-sensitive matching in SQL.
The LIKE operator in SOQL and SOSL supports escaping of special characters % or _.
Do not use the backslash character in a search except to escape a special character.

Comments

Unknown said…

how to use like operator in SOSL query?

17 September 2015 at 10:15

Unknown said…

How to use LIKE operator in SOSL query

17 September 2015 at 10:16

Asish Kumar Behera said…

Hi Pramodh T

Sorry for late reply, Here is link to answer your question.

http://salesforceworld4u.blogspot.in/2015/10/how-to-use-like-operator-in-sosl.html

1 October 2015 at 03:14

Unknown said…

Like operator in sosl

25 May 2021 at 08:20

How to Create a Tooltip in Lightning Datatable ?

Imagine you have a datatable displaying a list of Contact records , and one of the columns shows the Account Name . The Account Name is a hyperlink that allows users to navigate to the Account record page. But what if users want to take a quick glance at some key Account fields —like Phone or Address—without navigating to the Account record? In Salesforce Classic, this was achieved using the Mini Page Layout feature from standard page. However, in Lightning Experience, we can implement a similar feature by adding a tooltip to the data table. Solution Overview: We’ll create a Lightning Web Component (LWC) that: Displays a data table with a clickable Account Name . Provides a tooltip that shows the Account's Phone and Address fields when users hover over the Account Name. Implementation Steps: 1. Data Preparation We need to retrieve the following fields for each Contact and its associated Account: Contact Fields : Name, Phone, Email Account Fields : Name, Phone, Billing Addre...

How to Create/Delete file attachments(Content Document) through Apex ?

There are 3 standard salesforce objects to store file attachments. Content Document, ContentDocumentVersion, ContentDocumentLink. Here is the article to talk about these objects and relationship. https://www.forcetalks.com/blog/contentdocument-and-contentversion-in-salesforce-an-overview/ ContentDocumentVersion ContentDocumentLink This post is all about how to create/delete content document though Apex. Here is code snippet // Insert Content Version record ContentVersion contentVersionRec = new ContentVersion(Title='filename',PathOnClient ='FileName.pdf',VersionData = bodyBlob,origin = 'H'); INSERT contentVersionRec; // this will insert one record in ContentDocument and ContentVersion , ContentDocument is parent and ContentVersion is child record // get contentdocument id contentVersionRec = [SELECT Id, Title, ContentDocumentId FROM ContentVersion WHERE Id = :contentVersionRec .Id LIMIT 1]; // Create Content Document Link record- This will attach ...

Lifecycle hooks in LWC

There are 3 phase of LWC component 1. Mounting A. constructor, B. connnectedCallback C. render D. renderedCallback 2. UnMounting A. disconnectedcallback 3. Error A.errorcallback Note - render is not lifecycle hook, it is protected method of Lightning element class. Mounting Phase LWC Creation and Render Life cycle Constructor Method · This method called when component is instantiated and It flows from parent to child component. · Need to call Super() inside constructor method · Can’t access any component properties or child component because it’s not ready yet. · Host element can be accessed through “this. template” inside constructor method. · Don’t add any attributes to host inside constructor C constructor (){ super (); //...

Salesforce4U

Search This Blog