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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.