Issue Summary

ROOT CAUSE IS ON THE COMMENTS

We have a Confluence page where a task report macro is used to collect action tasks from meeting notes on the same page. The macro does not collect all open tasks and incorrectly lists some tasks that are already marked as done. Additionally, the issue causes the visualization of incorrect IDs in the database, which differ from those reported in the ADF code of the page. The page can generate new IDs for action items but fails to update them in the database.

Steps to Reproduce

Unable to replicate it internally, however, it looks like when an emply task macro is created it resets the global id incremental value

1. Navigate to the Confluence page with the task macro.
2. Enter empty items in the action tasks.
3. Observe that not all open tasks are collected, and some completed tasks are listed.
4. Check the database for task IDs and compare them with those reported in the ADF code of the page.

Expected Results

The task report macro should collect and display only open tasks from the meeting notes, and the IDs should match between the database and the ADF code.

Actual Results

The task macro fails to collect all open tasks, lists some tasks that are already marked as done, and visualizes incorrect IDs in the database.

Workaround

The NULL values were removed from the database table. After this cleanup, existing task entries were automatically updated to match the correct ID, and new tasks were created with a new ID. However, the issue of incorrect ID visualization persists and needs further investigation.