• App appstatus
  • NEWBIE
  • 0 Points
  • Member since 2021

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
 
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)];
can we do gmail integration thru community.please advise