Hi All,
I see the table - T_AV_AFX_REQUEST gives the AFX commands along with their execution status. Is there a common attribute which can be used to connect this AFX table and the Request tables, so that query can be formed to get the afx status specific to each request.
T_AV_AFX_REQUEST.CHANGE_ITEM_ID is null when Provisioning command node is used, which is the case with most of our WF's.
If you are using Provisioning Command Nodes, this means that you are doing changes that are not necessarily tied to a specific change item.
Do you need this for a report, or just to fetch the status inside the workflow itself? If the latter, you may reference Usage of acm.provisioningCommandStatusCode Job variable after Provisioning command nodes
I was looking for the reporting feature.
T_AV_AFX_REQUEST.CHANGE_ITEM_ID corresponds to T_AV_CHANGE_REQUEST_DETAILS.ID