Issue Summary

The completion date for the Task report macro is not captured under the Profile task report. Instead of the actual task completed date, it shows "-" and displays the message "A completion date was not recorded for this task"

Steps to Reproduce

1. Install Confluence 9.2.2 with Postgres 15 or Oracle 19c.
2. Create a page with few tasks and complete one of them by ticking the checkbox
3. Add "Task Report" macro to the page and edit its properties
4. In the properties:
   1. change the Task status to Complete
   2. In Columns to Display add ,completedate at the end
   3. Save and publish the page
5. Notice the column of Completed Date shows as "-" . When you hover over it, it displays "A completion date was not recorded for this task"

Performed complete site Reindex from GUI. It did not help and same issue

Expected Results

Should display the completed date.

Actual Results

Completed Date shows as "-" . When you hover over it, it displays "A completion date was not recorded for this task"

Workaround

If we add the below dark feature, it works as expected:

1. Navigate to <confluence-url>/admin/darkfeatures.action
   • In the Enable dark feature box, add:
     • confluence.task-report.use-database-for-reports
   • Click Submit

Versions Tested

Confluence 9.2.0, 9.2.2, 9.2.3 with Oracle 19C DB and PostgreSQL 15