Skip to main content
Solved

Custom Event: How to Use attribute from Alternative Table

  • February 13, 2025
  • 2 replies
  • 31 views

Forum|alt.badge.img+7

Hi everyone,

How can I get an attribute from an alternative table?

I would like to get “Active Work Assignments” but this it is not in the main table (JTTASK).

 

Thanks

Best answer by SimonTestard

Active Work Assignments is a read only field, where the data is coming from this method.

 

You cannot create triggers, as actual data on the jt_task_tab table isn’t being modified.

 

Your event trigger would need to be set on jt_execution_instance_tab and you would need to do significant logic PLSQL logic (probably as an autonomous_transaction too) when the trigger executes in order to achieve similar results.

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 2 replies
  • March 10, 2025

Hello ​@Eleazar_AyaviriCarrillo ,

 

I am facing the same issue now. 

Did you find the solution for it?

 

Regards,
Waseem


Forum|alt.badge.img+12
  • Hero (Customer)
  • 252 replies
  • Answer
  • March 11, 2025

Active Work Assignments is a read only field, where the data is coming from this method.

 

You cannot create triggers, as actual data on the jt_task_tab table isn’t being modified.

 

Your event trigger would need to be set on jt_execution_instance_tab and you would need to do significant logic PLSQL logic (probably as an autonomous_transaction too) when the trigger executes in order to achieve similar results.


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