case sensitive check in view criteria query
Summary:
How to case sensitive check in view criteria query
for the lead name field while creating a duplicate lead
Content (please ensure you mask any confidential information):
I need to check for case sensitive in view criteria query using UPPER(Name) to check for lead name with all cases. But its throwing an error.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
def vo = newView('Lead');
def leadNameToCheck = Name.toUpperCase();
def vc1 = newViewCriteria(vo)
def vcr1 = vc1.createRow()
def vci1 = vcr1.ensureCriteriaItem("UPPER('Name')")
vci1.setOperator('=')
0