How to display the report for a specific date range.

This article explains how to display the report for a specific date range using Run Self-Service Reports and SQL for Confluence app.

Instructions

Follow the below steps:

1. Log into the Confluence instance.

2. Navigate to the required page and click the Edit icon ().

3. Add the macro Run with user form and parameters to build the form.
4. Click Edit to open the macro setting window.
   
5. Add the fields to the form based on the field requirement.
   
   
   
6. Click Save settings and Save the page.
   
7. Add the SQL Query macro under the Run with user form and parameters macro. Enter {sql or search for the SQL for Confluence macro.
   
8. s
9. s
10. s
11. s
12. s
13. s
14. s
15. s
16. s
17. s
18. s
19. s
20. s