«Atlassian Confluence Advanced Permission and Security Management» course released! Try it now!
Skip to end of metadata
Go to start of metadata
Managing Date Range Filters

Table Filter and Charts for Confluence add-on is equipped with the date range filter. You can add this filter type for any column of your table containing dates. It allows you to specify the date range for showing data in the table. Alternatively, you can set the start or end value instead of the number range. You can either select the date format from the pre-defined ones or manually specify the required date format.

 

 

Adding the Date Range Filter

  1. Edit the page.
  2. Insert the Table Filter macro and paste the table within the macro body.
  3. Select the macro and click Edit.
  4. In the Date range filter columns box, select the columns for filtration with date range filters.
  5. Switch to the Filtration tab and specify the correct date format.
  6. Save the macro.
  7. Save the page.

 

 

Filtering the table with date range filters

  1. Open the page with the table for filtration.
  2. On the filtration pane, locate the date range filters and position the mouse pointer within the appropriate one.
  3. Enter the appropriate date range or pick the start/end date for filtration.

You can use the dynamic date for today, that will automatically update filtered results upon change of the today's date.

In the date range filter enter 'Today'.


 

 

Filtering the table with date and time values

This option is available since Table Filter and Charts 4.0.0.

  1. Open the page with the table for filtration.
  2. Add the date filter.
  3. Click the cogwheel button and select Modify Settings.
  4. Set the correct date and time format for your table data. For example, 'yy-mm-dd hh:mm:ss'.
  5. Set the date and time values for data filtration.

For the details on entry of date and time formats, please see our FAQ.



Setting Dynamic Time Interval

You can set the dynamic time intervals in the date picker in the following format:

  • +/-Xy - for setting yearly intervals in future or in past.
  • +/-Xm - for setting monthly intervals in future or in past.
  • +/-Xw - for setting weekly intervals in future or in past.
  • +/-Xd - for setting the daily intervals in future or in past.

If you need to set some complex interval, enter it as a single string, like: -2m 3w 5d. The current browser date is used as a starting date for data filtration according to the specified time intervals.

  1. Open the page with the table for filtration.
  2. On the filtration pane, locate the date range filters and position the mouse pointer within the appropriate one.
  3. Enter the appropriate date interval in the correct date format.

  • No labels