Tuesday, 14 March 2017

[#Blogged]Like operator in SOQL

Like operator in SOQL

 Like keyword is same as like in SQL. We can find/get the record utilizing this keyword. Expression is true if the value in the designated fieldname matches characters of text string in the designated value.
The LIKE operator in SOQL and SOSL is homogeneous to the LIKE operator in SQL; it provides a mechanism for matching partial text strings and includes support for wildcards.
* % and _ wildcards are fortified for LIKE operator.
    * % wildcard matches zero or more characters.
    * _ wildcard matches precisely one character.
    * Text string in the designated value must be enclosed in single quotes.
    * LIKE operator is fortified for string fields only.
    * LIKE operator performs a case-callous match, unlike the case-sensitive matching in SQL.
    * LIKE operator in SOQL and SOSL fortifies eluding of special characters % or _.
    * Do not utilize the backslash character in a search except to elude a character.

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

 SELECT AccountId, FirstName, lastname FROM Contact WHERE lastname LIKE 'AC_%'

Select id, email from contact where email like '%a' or email like '%x';

Wednesday, 8 March 2017

[#Blogged]Salesforce 18th Birthday

Happy Birthday Salesforce !
Salesforce have turned 18th today , Isn't it exciting the company you work and it grows with you .
 The company was founded in 1999 by former Oracle executive Marc Benioff, Parker Harris, as a company specializing in software as a service (SaaS).[8]
I still remember , the first time I heard the name 'Salesforce '

I started my salesforce journey in 2013 after my 12th Class examinations , And from solving Force.com Fundamentals to grabbing a job as a Salesforce Developer  and Being the DG Leader in Chandigarh Tricity Area . Salesforce just changed my life as well as the thinking of mine .I am still pursuing my graduation and I literally don't think any other technology gives you a life-changing chance as Salesforce did.
I would like to thank and wish “Happy Birthday” to all Salesforce Employees, Customers, Partners, Non-Profit Organizations etc.=Party Hard ! Salesfor