Page Comparison

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

Instructions

...

1. Log into the your Confluence instance.

2. Navigate to the required page and click the Edit icon (Image Removed)click Image Added.
3. Add the macro Insert Run with a user form and parameters to build macro to build the form.
4. Click Edit to open the macro setting settings window.
   Image RemovedAdd the fields to the form based on the field requirement.
   Image Removed
   Image Removed
   Image RemovedImage Added
5. In Field settings, click +Add field to add fields to the form. Ensure to select Field type as Date for at least two fields so as to provide a date range.
   Image Added
6. Enter the name of the button in the Run button text field. This ensures that a button with the given text is displayed on the form.
   Image Added
7. Click Save settings and Save the page.
   Image RemovedAdd the The form is displayed as follows:
   Image Added
8. Insert SQL Query macro under inside the Run with a user form and parameters macro. Enter {sql or search for the SQL for Confluence macro.
   Image Removed
9. s
10. s
11. s
12. s
13. s
14. s
15. s
16. s
17. s
18. s
19. s
20. s
21. s

...

1. 
   Image Added
2. Edit the SQL Query macro to open the settings pop-up.
3. Select the required Data source profile from the drop-down.
   Image Added

4. Enter the SQL statement based on the Field key mentioned in step 5.
   In the following query, the CAST operator is used to convert the literal strings'2003-01-01' and '2003-12-31' to DATE values.
   

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

   
   Image Added

5. Click Save settings and Save the page.
   
6. Enter the date range or select the dates based on the date format mentioned in step 5, and click Show Data on the form.
   Image Added

The given example displays the following information:
Image Added
If the user entered a date in an incorrect format (that is, not in the format as specified in the Date format field in step 5), error messages are shown as:
Image Added

Info
The Field key used in the Run self-service report macro is to input data using the SQL query.