Skip to main content
Nintex Community Menu Bar

How is a Lazy Approval indicated in the nintex tables?

  • May 7, 2019
  • 2 replies
  • 23 views

Forum|alt.badge.img+8

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.

2 replies

JakeFromNintex
Forum|alt.badge.img+3

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.


Forum|alt.badge.img+4
  • Nintex Employee
  • July 31, 2019

Hi @vacoder 

 

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. 

 

 

3736iB7D0B928862DD0C2.png