Tuesday, 13 September 2016

Code for Department

   select firstOnly ITLHRWorkerTransfer
    order by assignmentstartdatenew desc
     where  ITLHRWorkerTransfer.PersonnelNumber == ITLPayReimbursementApplication.EmplID &&
            ITLHRWorkerTransfer.WorkflowApprovalStatus == ITLWorkflowApprovalStatus::Approved;
    dimStorage = DimensionAttributeValueSetStorage::find(ITLHRWorkerTransfer.DimensionDefaultNew);

      for (i= 1 ; i<= dimStorage.elements() ; i++)
      {
        if(DimensionAttribute::find(dimStorage.getAttributeByIndex(i)).Name == "Department")
          {
            select _omoperatingunit where _omoperatingunit.OMOperatingUnitNumber == dimStorage.getDisplayValueByIndex(i);
            ITLPayAppChildTMP.Department = _omoperatingunit.Name;
          }

       }

No comments:

Post a Comment

8 Common Errors in Dual-write

502 Bad Gateway : when the target application is not ready to handle the incoming request  401 Unauthorized / 403 Forbidden: This error occ...