...
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 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".
- 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".
- "10th of last month - 24th of this month" - This displays all records from the 10th of last month to the 24th of this month.
Change Search Terms on an Existing Filter
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 button.
Change Search Terms on an Existing Filter
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 button.
...