Workflow check for employee in D365

Hello Everyone,

Below code will help to check if employee is having any pending workflow.

// workflow validation

DirPersonUser    personUser;

HcmWorker        worker;

WorkflowWorkItemTable   workflowWorkItemTable;

HcmPersonnelNumberId    employeeId = "20449";

select firstonly * from personUser

exists join worker

where personUser.PersonParty == worker.Person

        && worker.PersonnelNumber == employeeId;

select firstonly * from workflowWorkItemTable

where workflowWorkItemTable.Status == WorkflowWorkItemStatus::Pending

    && workflowWorkItemTable.UserId == personUser.User;

if (workflowWorkItemTable.RecId)

{

    throw error('Workflow for user exist.');

}

Thanks & Regards

Avinash Patil