Check Pending Workflow Work Item for Purchase Requisition

This method checks whether the specified PurchReqTable record has a pending workflow work item assigned to the current user. It searches WorkflowWorkItemTable using the purchase requisition table and record references, pending status, and current user ID. The method returns true when a matching work item exists; otherwise, it returns false.

X++ Code

public static boolean hasPendingWorkItem(PurchReqTable _purchReqTable)
    {
        WorkflowWorkItemTable workItem;
        select firstOnly RecId from workItem
            where workItem.RefTableId == tableNum(PurchReqTable)
&& workItem.RefRecId   == _purchReqTable.RecId
&& workItem.Status     == WorkflowWorkItemStatus::Pending
&& workItem.UserId     == curUserId();

        return (workItem.RecId != 0);
    }

Process Flow

The method receives a PurchReqTable record and searches WorkflowWorkItemTable for a matching work item.

The query checks the purchase requisition table ID, record ID, pending workflow status, and current user ID.

If a matching work item is found, its RecId is non-zero and the method returns true.

If no matching work item exists, the method returns false.

Figure: Flow of checking a pending workflow work item for a purchase requisition and current user.