Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note: You may add as many Filters as you like to the same column or multiple columns. When a filter is added to a column, a Filter Icon is placed in the header. Note: you can make the search even more specific by clicking on the Filter Type drop-down and choosing one of the other search options. The options shown depends on the type of data in that column.

Advanced Filtering

Users have the ability to search relative dates using the Date/Time filters. If the User searches using x days to y days, "Through", "thru", and "to", are interchangeable and will provide the same result. The "+" is for future dates, and the "-" is for past dates. Additionally, the language parsing will take all of these values: "Year/Years" "month/months" "day/days" "week/weeks" "hour/hours" "minute/minutes" "second/seconds". 

  •  " to -30 days" - For all records older than 30 days.
    • The space before " to" is critical for past dates. The parser will not recognize this string: "to -30 days" but will recognize " to -30 days". 
      All records older than 30 daysImage Added
  • "10th of last month - 24th of this month" - This displays all records from the 10th of last month to the 24th of this month.
    all records from the 10th of last month to the 24th of this monthImage Added

Change Search Terms on an Existing Filter

Filtering Example ImageImage Added
Click the column header of the Search Term you wish to change. Once you've opened the Filter you can click on the existing Search Term to populate the Value field. After you've changed it to the desired value, click the Update FilterImage Added button.

Change Search Terms on an Existing Filter

Filtering Example Image
Click the column header of the Search Term you wish to change. Once you've opened the Filter you can click on the existing Search Term to populate the Value field. After you've changed it to the desired value, click the Update Filter button.

...