RE: How to see list of all workflow items pending/assigned/delegated for a particular user id
Hi
To view a list of workflow items with a specific status for a particular user in Dynamics AX, you can follow these steps:
Go to the "Inquiries" section of the Dynamics AX menu.
Click on "Workflow" and then "Work items assigned to me".
In the "Work items assigned to me" form, click on the "Advanced filter" button.
In the "Advanced filter" form, go to the "Status" field and select the status you want to filter by (e.g. "Pending", "Assigned", "Delegated").
In the "Advanced filter" form, go to the "User ID" field and enter the user ID of the user you want to filter by.
Click "OK" to apply the filter.
This should give you a list of all the workflow items with the selected status assigned to the specified user.
If you want to know which table and field store the user ID and name for each workflow item, you can look at the "Workflow work item" table (WHSWorkItemTable) in the Dynamics AX database. The "User ID" field (UserId) stores the user ID of the user assigned to the workflow item, while the "User Name" field (UserName) stores the name of the user.
DAniele
