Skip to main content

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

Hello ​@Eleazar_AyaviriCarrillo ,

 

I am facing the same issue now. 

Did you find the solution for it?

 

Regards,
Waseem

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


Terms & ConditionsCookie settings