Which repository database table and field stores info about each Task status?

[mwallman]

Hello,

I have to create a report which gives info on the status of each Task as shown in the Task page.

Which repository database table and field stores info about each Task status?

[s_kabir_rab]

Hi,
From top of my head you will need to join on few tables to get the result. Tables you need are :
ExecutionResult
ExecutionResultDeatailsExecutionResult
ExecutionResultDeatails
ReloadTasks
ReloadTasksOperational

Note: i am not on the server. This is from a note i made a while back. I use API now but the tables should still be the same.

Have you considered using the QRS API? Would give you all the tasks details as you see them on the QMC. Also you wouldn't need to worry about database chages from version to version. API for task is stable.

You can try looking at - get /reloadtask endpoint. Status is a code. There is a lookup for the code on - get /about/api/enum endpoint.
Ex filter: "UsageType" : "ExecutionResult.Status".