I have the need to query a nintex table to determine if a workflow task was responded to via Lazy Approval. I'm wondering if someone could tell me what table.coumn stores the indicator for a lazy approval.
Solved! Go to Solution.
Hi @vacoder ,
I believe the table you are looking for is dbo.HumanWorkflowApprovers. This will provide you with the Comments (added from the LazyApproval response) and even have the Outcome column, which is tied to the dbo.ConfiguredOutcomes table.
You could query the humanworkflowapprovers table, comments column should record the response if it has been approved by Lazy Approval.
Here's a sample query that you can run, this needs to be run on the database mapped to the site.