Recalculate workflow step when personhead change

Question

Hi, 
 
 in my workflow I have a custom decisione method witha query that return me the approver for that step based on a query that watch on a custom table where I have the approvers for a certain deparment. 
 So when I have to retrieve the approver for a request for a Person I get the deparment of that person and query my custom table with the UID of the department returning all approver for that department (is more complicated but the base concept is this). 
 When I change entry in this custom table I'd like to check if there is any approver in my PWOHelperPWo that is changed in my custom table and recalculated the approver for every step the old approved were involved. 
 How can I do that? 
 
 Michele

Barry Jackson · Answer

Hi Michele, 
 Which version of 1IM? 
 In v6 if you have a CP (Calculated Group Of Approvers) you could create a process chain that would run the SQL Component - Execute SQL 
 The SQL would be like this: 
 Dim f As ISqlFormatter = Connection.SqlFormatter 
 Value = f.StoredProcedure("vi_ReCalcPWOHelperPWO","'|CP|'", "'" & CStr(Connection.Variables("GenProcID")) & "'") 
 You would fire the process chain off some event where the department approvers change I guess or you can run it on a schedule. 
 The equivalent in V7 is QER_PITShopHelperFillAll which takes an argument for the custom decision rules. 
 HTH, Barry.

Barry Jackson · Answer

Hi Michele, 
 
OK so you'll need to use QER_PITShopHelperFillAll ...... I would experiment with it in DEV ..... to make sure you pass the right arguments ...... it takes a parameter of @DecisionRules but I'm not certain on the syntax. 
 
Regards, Barry.