03-21-2017 06:45 AM
03-21-2017 06:57 AM
Hi mavala,
Which version are you on?
I'm using v10 and can see this info listed in (DB is SQL) dbo.TxRequisitionEntry. StatusID appears to correspond to Status.
03-21-2017 07:05 AM
Hi,
Thank you for your reply. Yes you're correct, I can query TxRequisitionEntry and it does fetches records corresponding to a specific Requisition Id.
However, the status e.g. "Completed" or "Failed" is missing. Capturing this status for the corresponding task / subject for a specific Requisition ID is intention.
For the record I queried, it says Status ID as "1".
When I manually check Service Link > View Transaction page for the same Requisition ID, it says one of the tasks failed.
But I'm unable to fetch this failed task by querying.
Regards,
Manish
04-06-2017 08:26 AM
Hi Manish,
Did you find the table?
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: