You need to sign in to do that
Don't have an account?
Pallavi singh
Errors in the apex class to query
Hi,
I get this errors while quering.
public with sharing class DuplicateCasesController {
@AuraEnabled
public static List<Case> getDuplicateCases(Id recordId) {
Case currentCase = [SELECT CaseNumber, IncomingEmail__c, Status FROM Case WHERE Id = :recordId];
String emailSubject = currentCase.IncomingEmail__c;
String caseNumber = currentCase.CaseNumber;
String lowerEmailSubject = emailSubject.toLowerCase();
List<Case> duplicateCases = [SELECT CaseNumber, Status, RelatedTo__c
FROM Case
WHERE Id != :recordId
AND ((LOWER(IncomingEmail__c) LIKE :('%'+caseNumber+'%') AND LOWER(IncomingEmail__c) != 'wg')
OR (LOWER(IncomingEmail__c) = 'wg' AND LOWER(CaseNumber) = :caseNumber))];
for (Case duplicateCase : duplicateCases) {
if (lowerEmailSubject.contains(duplicateCase.CaseNumber.toLowerCase())) {
duplicateCase.RelatedTo__c = duplicateCase.CaseNumber;
} else {
duplicateCase.RelatedTo__c = 'WG';
}
}
return duplicateCases;
}
}
How to solve this errors
Thank you
Pallavi
I get this errors while quering.
public with sharing class DuplicateCasesController {
@AuraEnabled
public static List<Case> getDuplicateCases(Id recordId) {
Case currentCase = [SELECT CaseNumber, IncomingEmail__c, Status FROM Case WHERE Id = :recordId];
String emailSubject = currentCase.IncomingEmail__c;
String caseNumber = currentCase.CaseNumber;
String lowerEmailSubject = emailSubject.toLowerCase();
List<Case> duplicateCases = [SELECT CaseNumber, Status, RelatedTo__c
FROM Case
WHERE Id != :recordId
AND ((LOWER(IncomingEmail__c) LIKE :('%'+caseNumber+'%') AND LOWER(IncomingEmail__c) != 'wg')
OR (LOWER(IncomingEmail__c) = 'wg' AND LOWER(CaseNumber) = :caseNumber))];
for (Case duplicateCase : duplicateCases) {
if (lowerEmailSubject.contains(duplicateCase.CaseNumber.toLowerCase())) {
duplicateCase.RelatedTo__c = duplicateCase.CaseNumber;
} else {
duplicateCase.RelatedTo__c = 'WG';
}
}
return duplicateCases;
}
}
How to solve this errors
Thank you
Pallavi
Can you confirm if IncomingEmail__c is of type checkbox or text? Thanks