Skip to main content
Question

Conditional expressions in Value type Business Rule

  • February 15, 2022
  • 1 reply
  • 154 views

Forum|alt.badge.img+8

Hi, 

I am trying to implement a conditional expression for a value type Business rule. My condition is below

TDC_TASK_EXT.USER_DEF103 IS NULL?1100:C_JOB_CODE.BASE_VALUE

If the value for TDC_TASK_EXT.USER_DEF103 is Null, it should set the value for TASK.USER_DEF_NUM2 as 1100 and if Not Null, it should set the value of C_JOB_CODE.BASE_VALUE.But it is always setting the value as 1100. So it seems that Boolean result for highlighted (in yellow) condition is always being true.

Could someone help me understand what I am doing wrong here?

Mike The FSM TechnoGeek
Superhero (Employee)
Forum|alt.badge.img+17

Make sure that you have force_select = ‘Y’ set for TDC_TASK_EXT.USER_DEF103.  My guess is that FSM is not retrieving the value from the database, so it’s always null for the condition.

Is your custom business process triggered on a TASK table transaction?  If not, try the whole custom business process against the TASK table, referencing the extension fields as if they were part of the TASK table rather than the extension table.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings