Page Comparison

...

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. sEdit the macro and select the Data source profile.
    Image Added

20. Enter the SQL statement based on the Field key mentioned in the Step5.

    Code Block
    language sql
    Select * from tabel_name where column_name BETWEEN CAST('$date2' AS DATE) AND CAST('$date1' AS DATE);

    
    Image Added

21. Click Save settings and Save confluence page.
    
22. Enter the date range based on your requirements and click Show Data on form.
    Image Added
    Data shown as below.
    Image Added
23. s