It's very simple by using just once Global data restriction based on conditions.
1. create an expression using Conditional expression Manager (copy this)
(:ACTIONID in (selectdistinct ACTIONIDfromWFACTIONwhere1 = 1and PROCESSNAME = 'SR'and PROCESSREV='1'))
2. Create Global Data Restriction -> Attribute Restriction -> New Row
Object | : | INPUTWF |
Attribute | : | MEMO |
Application | : | SR |
Type | : | QUALIFIED |
Reevaluate | ? | y |
Condition | : | myCondition (the one we created in step 1) |
Just a note for anyone trying this in a system with many different workflows.
ReplyDeleteI found an issue with this where ACTIONID is not unique across workflows so making one mandatory forced another to be mandatory in a completely separate workflow.
Had to build a script to resolve it as the issue was not knowing which process we are currently on and this was not available through SQL.