I have 2 tables, task and agenda. Task is the table of all recurrent task. Agenda is the table for the task day by day. Agenda is refresh all days at 12:00am with the task.
At 12:00am, all task with the “recurrence ID” (rec001) must be added on table agenda.
how to add all task IDs