Column filter

Modified on: Mon, 4 Mar, 2019 at 11:28 AM

Print

Filters are usually not shown immediately. You can access all available filters by clicking on the  button on the top-left of the table.




Tables in the reporting section are an exception. They always show filters.



To filter a column:

  1. Specify the filter criteria for each column you want to filter. If you set no filter value for a column, then the system will interpret this as ‘return any value for this column’.
  2. Click the “Filter” button to the right of the filters.
  3. The system will filter the list results based on the filter settings.
  4. If the filter does not return any results, then the table will still be displayed and a message appears.  

  5. To reset the filter, clear every filter field and click the “Filter” button.


Depending on the column type, the filter shall provide different entry possibilities:

  1. Text / IDs: the list will be filtered to only show results in the list that contain the phrase entered in the filter field.
  2. Predefined list: select the value to filter the list to from a dropdown list.
  3. Amount / Price fields: enter a minimum value, a maximum value or a range (between the minimum value and the maximum value) and the list will show results that fit within the range entered in the filter.
  4. Dates: enter a start date, an end date or a range (between the start date and the end date) and the list will show results that fit within the date range entered in the filter.
  5. Runtime: enter a start date-time, an end date-time or a range (between the start date-time and the end date-time) and the list will show results that fit within the date range entered in the filter.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.