Skip to main content

IFS version:  IFS Cloud 24R1SU5

 

I have an event action (workflow) that I would like to activate when a custom attribute from an Event has certain values:

 

Custom attribute is titled “INVENTORY_FLAG” and defined below:

Purchase_Part_API.Get_Inventory_Flag(&NEW:CONTRACT, &NEW:PART_NO)

 

The possible values returned from this custom attribute are “Inventory Part”, “Non Inventory Part” or NULL.  I would like the workflow to run when the value returned is “Non Inventory Part” or NULL.  Will the following satisfy that?  I worry about NULL...

 

 

Only way I could do this was with two events  for the same table with 1 event action for  each. 1 event action has condition is null and other has the condition “equals (=)” for the string you want.

There is another way to use custom plsql in the event and add a custom attribute.
Say the custom attribute is WF_SHOULD_FIRE. This custom attribute can resolve the logic you want using a plsql function. Then in the event action you should be able to user the conditions WF_SHOULD_FIRE = TRUE. Please note that I have not tried this.


Only way I could do this was with two events  for the same table with 1 event action for  each. 1 event action has condition is null and other has the condition “equals (=)” for the string you want.

There is another way to use custom plsql in the event and add a custom attribute.
Say the custom attribute is WF_SHOULD_FIRE. This custom attribute can resolve the logic you want using a plsql function. Then in the event action you should be able to user the conditions WF_SHOULD_FIRE = TRUE. Please note that I have not tried this.

 

I cannot believe I never thought of this before… makes total sense that two event actions would be fine since the conditions would never match.  Glad I posted the question, and thank you for the answer!


Reply