Aproval procedures: Recalculation query?

What is the current advise on using the 'Query for recalculating' in custom Aproval procedures.
This query option is no longer shown in the Manager (from 9.1 and up I think) even if you enable the expert mode.
Aproval procedures > Change queries for approver selection: Recalculation query

It is still referenced in the docu. But without any examples/advise?
https://support.oneidentity.com/technical-documents/identity-manager/9.3/it-shop-administration-guide/29#TOPIC-2288200
Query for recalculating: Database query for finding request procedures that require recalculation of their approvers
(PWODecisionRuleRulerDetect.SQLQueryObjectsToRecalc)

OM - Manager of a specific role:

select pwo.UID_PersonWantsOrg, pwo.UID_QERWorkingMethod, pwo.GenProcID, pwo.OrderState
from personwantsorg pwo join QERWorkingStep s on s.UID_QERWorkingMethod = pwo.UID_QERWorkingMethod
join @ObjectKeys ok on s.ObjectKeyOfAssignedOrg = ok.Parameter1

Regards,
Niels

Top Replies

Markus Weiss-Ehlers 21 days ago +1 verified

Hi Niels,

The query for recalculating was removed from the form in the Manager because it only works with ootb approval procedures (docs.oneidentity.com/.../itsapproverrecalculation.htm). For a custom approval…

+1 Markus Weiss-Ehlers 21 days ago

Hi Niels,

The query for recalculating was removed from the form in the Manager because it only works with ootb approval procedures (docs.oneidentity.com/.../itsapproverrecalculation.htm). For a custom approval procedure, more low-level changes (like custom triggers) would be necessary.
Cancel
Up +1 Down

Reply

Reject Answer

Cancel
0 Niels de Groot 21 days ago in reply to Markus Weiss-Ehlers

Thank you Markus!
Cancel
Up 0 Down

Reply

Verify Answer

Cancel