Hi,

The requirement is to retrieve the value for WO No using an API call and to assign that value to a variable, so that it can be inserted into a custom field in Miscellaneous Resource Allocation page. The code to retrieve WO No value is shown below. The environment is IFS Cloud 22r2.

SELECT Jt_Task_API.Get_Wo_No(task_seq) from SELECT Jt_Task_API.Get_Wo_No(task_seq) from JT_TASK_CLOCKING_TAB a WHERE a.C_allocation_no=:allocation_no AND a.C_resource_seq=:resource_seq a WHERE a.C_allocation_no=:allocation_no AND a.C_resource_seq=:resource_seq

Is there a way to read (which is retrieved using an API call from the database) and assign that WO No value into a variable in a workflow?