You need to sign in to do that
Don't have an account?
Dastagiri Basha
List<Employee__c> empList;
AggregateResult[] atteList;
AggregateResult[] LeaveList;
if(empIds.size() >0){
empList = [SELECT Id,Name,Basic_Salary__c,Employee_ID__c FROM Employee__c WHERE Not (Id IN :empIds)];
atteList = [SELECT Count(Id)cnt,Employee__c FROM Attendance__c WHERE Month_and_year__c=:monthYear AND (NOT (Employee__c IN : empIds)) GROUP BY Employee__c];
LeaveList = [SELECT SUM(No_of_Days__c)noL,Employee__c FROM Leave__c WHERE Month_and_year__c=:monthYear AND (NOT (Employee__c IN : empIds)) AND (Approval_Status__c ='Accept' OR Approval_Status__c ='Edit & Accept') GROUP BY Employee__c];
}__c WHERE Not (Id IN :empIds)];
Hii All, I want to write a test class for below query, Can any one help me
AggregateResult[] atteList;
AggregateResult[] LeaveList;
if(empIds.size() >0){
empList = [SELECT Id,Name,Basic_Salary__c,Employee_ID__c FROM Employee__c WHERE Not (Id IN :empIds)];
atteList = [SELECT Count(Id)cnt,Employee__c FROM Attendance__c WHERE Month_and_year__c=:monthYear AND (NOT (Employee__c IN : empIds)) GROUP BY Employee__c];
LeaveList = [SELECT SUM(No_of_Days__c)noL,Employee__c FROM Leave__c WHERE Month_and_year__c=:monthYear AND (NOT (Employee__c IN : empIds)) AND (Approval_Status__c ='Accept' OR Approval_Status__c ='Edit & Accept') GROUP BY Employee__c];
}__c WHERE Not (Id IN :empIds)];
App appstatus
This is i think so code issue please check it again . (https://bestappsapk.com/teatv-apk-10-3-1/)