Aproval procedures: Recalculation query?

Question

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

Markus Weiss-Ehlers · Accepted Answer

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.

Aproval procedures: Recalculation query?

Top Replies