You need to sign in to do that
Don't have an account?
ExploreForce
SOQL query: help
Return list of potential contact based on
===========================================================================
1. derived email .@example.com-->(firstname+lastname@example.com)
2. and first initial of first name and full last name.(firstname(firstinitial) and lastname='fullname')
3. email provided on recruiting contact (email on contact)
====================================================================
contactList = [Select c.Id,c.My_Key_Partner__c,c.FirstName,c.LastName,c.Name,c.Email,
c.My_Contact__c,c.RD_Contact__c, c.User__c, c.RecordTypeId,
c.OwnerId, c.Owner.ManagerId
From Contact c
Where c.Id = : recontactId
or c.email=c.FirstName+c.LastName+'@scotiabank.com'
or c.FirstName= 'A%' and c.LastName='%'
or c.email='%@%.com'];
Please help:
Thanks
===========================================================================
1. derived email .@example.com-->(firstname+lastname@example.com)
2. and first initial of first name and full last name.(firstname(firstinitial) and lastname='fullname')
3. email provided on recruiting contact (email on contact)
====================================================================
contactList = [Select c.Id,c.My_Key_Partner__c,c.FirstName,c.LastName,c.Name,c.Email,
c.My_Contact__c,c.RD_Contact__c, c.User__c, c.RecordTypeId,
c.OwnerId, c.Owner.ManagerId
From Contact c
Where c.Id = : recontactId
or c.email=c.FirstName+c.LastName+'@scotiabank.com'
or c.FirstName= 'A%' and c.LastName='%'
or c.email='%@%.com'];
Please help:
Thanks
Try with below code.