Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
bgColorwhite
titleBGColor#f5f5f5
titleManaging Date Range Filters

Table Filter 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.

Widget Connector
width432
urlhttps://www.youtube.com/watch?v=8u3c3h91XO4&list=PLRpx9wuFqlzFa9X4DWwQEBdy22YIwT6kh&index=5
height243

 

 

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 the Date range filter columns box, select the columns for filtration with date range filters.
  5. Switch to the the Filtration tab  tab and specify the correct date format.
    Image Removed
  6. Save the macro.
  7. Save the page.

Image Added

 

 

Filtering the table with date range filters

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

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


Widget Connectorwidth432urlhttps://www.youtube.com/watch?v=8u3c3h91XO4&list=PLRpx9wuFqlzFa9X4DWwQEBdy22YIwT6kh&index=5height243

Image Added