Environment: Oracle APEX v5.1.2 with Oracle 12c R2 Database
I have created a report based on the columns of a table named MY_TASK. The columns include:
TASK_ID (Primary Key),
TASK,
TASK_STATUS (from TASK_CHECKER.task_status)
In addition, I use another table called TASK_CHECKER as a running table to monitor the status of jobs related to TASK_ID numbers from the MY_TASK table. This table has the following columns:
TASK_ID (Primary Key),
TASK_STATUS
To handle this setup effectively, I have scheduled a job that regularly checks the status of another table for specific TASK_IDs and updates the TASK_STATUS value in the TASK_CHECKER table.
When users access the Oracle APEX application, I want to display the TASK_STATUS at the time within the MY_TASK report by joining the two tables together via TASK_ID using apex.server.process during startup.
It is important to note that the TASK_STATUS values can be: WAITING, IN-PROGRESS, SUCCESS, or FAILED.
For example, upon initial page load with 5 TASK_IDs running, the report might show:
1 TASK_A SUCCESS
2 TASK_B ERROR
3 TASK_C IN-PROGRESS
4 TASK_D WAITING
5 TASK_E WAITING
And after about 10 seconds, it could update to:
1 TASK_A SUCCESS
2 TASK_B ERROR
3 TASK_C SUCCESS
4 TASK_D SUCCESS
5 TASK_E IN-PROGRESS
The goal is to allow real-time updates of TASK_STATUS to reflect changes dynamically.