SQL to look up prompt set/object variable values of a task

Discussion created by Michael_Lowry on Apr 5, 2018
Latest reply on Apr 6, 2018 by Michael_Lowry
I’m would like to construct an SQL query that will retrieve prompt set values from a task that has completed. I’d like to retrieve the values one would see if one displayed under Object variables in the Details of the task from task’s executions or statistics. I want a query that will return the correct values regardless of whether the task was run in a workflow, and regardless of whether the prompt set values were overridden at the task level. I have not completely figured out where all of these data are stored, and what the order or precedence is. Can anyone help?