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) |