Page Comparison

This article 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 apps.

Instructions

Follow these steps:

...

1. Log into the your Confluence instance.

2. Navigate to the required page and click the Edit icon (Image Removed)click Image Added.
3. Insert Run with a user form and parameters macro to build the form.
4. Click Edit to open the macro settings window.
   
5. In the In Field settings, click +Add field to add additional fields to the form.
   a. Since we need a report for a date range, make sure you have Ensure to select Field type as Date for at least two fields with Date type (choose Field type as Date).
   Image Removed
   Image Removed
   b. so as to provide a date range.
   Image Added
6. Enter the name of the button in the field: the Run button text field. A  This ensures that a button with the given text will be is displayed on the form to perform a specific action.
   Image RemovedImage Added
7. Click Save settings and Save the page.
   Image RemovedThe form is displayed as follows:
   Image Added
8. Insert SQL Query macro under inside the Run with a user form and parameters macro.
   Image RemovedImage Added
9. Edit the SQL Query macro to open the settings pop-up.
10. Select the required Data source profile from the drop-down.
    Image RemovedImage Added

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

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

    
    Image RemovedImage Added

12. Click Click Save settings and Save the confluence the page.
    
13. Enter the date range or select the dates based on the date format mentioned in Step5 step 5, and click Show Data on the form.
    Image Removed
    Data is shown as below:
    Image Removed
    If you enter the incorrect date format, then below error message will be shown.
    Image Removed

...

1. 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