Tuesday, 22 December 2020

Make Memo field mandatory on specific inputs in workflow | Maximo

 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 (
        select
            distinct ACTIONID
          from
            WFACTION
         where
            1 = 1
            and 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)

1 comment:

  1. Just a note for anyone trying this in a system with many different workflows.
    I 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.

    ReplyDelete