Is it possible to read the Nintex global task delegation data? This is required when we have approval system as plain email notifications (no Nintex approval). So before sending the email notification, we need to check if there is any delegation exists. If yes, send the notification to a delegated person. The global task delegations are setup here
Solved! Go to Solution.
Have found answer to my own question.
There is a table "Delegation" in Nintex config database that stores all the global task delegations. We can use "Execute SQL" action to find out if any global delegation exists before sending email notification. Example query
select delegate, StartDate, EndDate from [NWDBConfig].[dbo].[Delegation] where Username='i:0#.w|domain\user'