function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Pallavi singhPallavi singh 

Errors in the apex class to query

Hi,
I get this errors while quering.

User-added image

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




 
SwethaSwetha (Salesforce Developers) 
HI Pallavi,
Can you confirm if IncomingEmail__c is of type checkbox or text? Thanks