Filters

Purpose

This document provides an overview of the Filter and Settings panel feature.

Introduction

Common Settings include filtering options, and settings to customize the view.

Filters allow for quick limitation of viewed data to relevant entries. By applying filters in multiple columns, it is possible to narrow down a large dataset to find a particular entry or to discover any abnormalities, missing data or missing actions.

Example

When looking for a particular hostname (that includes a number in domain name) in Assets view, choose Hostname in the Type column and enter that number in the Name column to narrow down the search results. Additionally, a scanner ID can be submitted to ensure a direct search result.

Customize each view by adding or removing the columns and by applying filters. Each view has a Filter and Settings panel. To access it, click the filter icon in the bar spanning along the left edge of the table. This displays the Filter and Settings panel.

Inside the Filter panel, it is possible to add or remove columns, apply filters, view templates, and change column width and make it persist on your account.

Requirement

It is assumed that the reader has basic access to the OUTSCAN/HIAB account to access the Portal.

Filter Tab

To access the filtering, click the filter icon on the top right side of the screen. A list of available columns is displayed:

Use the Find Column field to quickly find the column name of choice in the list of applied filters.

Applying Filter

To apply a filter enter the filtration string either on the top of the column or in the Filter tab.

Filter Expression

Expression	Example	Description
?	Single character wildcard St??ng	Replace any character with the same number of "?". Example: W??d will find Word, Wood, and Wand but reject Would.
!	Exclude. !<string> !null	Excludes rows starting with <string>. Example: !Word excludes all rows starting with Word. Excludes empty rows.
null	Empty	Presents only empty rows
<	Less than number or date <10	Limits results to less than specified number. Only applicable to underlying numerical data such as numbers and dates. Example: <6.4 Includes only rows below 6.4 that are non-empty. Example: <2022-10-31 Includes only rows before 2022-10-31 that are non-empty.
>	Larger than number or date >0	Limits results to more than specified number. Only applicable to underlying numerical data such as numbers and dates. Example: >3.2 Includes only rows above 3.2 that are non-empty. Example: >2022-10-31 Includes only rows past 2022-10-31 that are non-empty.
-	Inclusive numerical range 3.2-7	Filters out items within the specified number range. Example: 1-5.5 will filter out items having the value 3.2 up to 5.5, inclusive.

Note

A filter can be applied in the background. This allows for enabling only columns of interest while filtering by any columns, without the need of specifically having them visible in the table to enable filtering. Pay extra attention to the Filter counter beside the column name to see how many filters are applied to the table.

Date Filters

Date specific filters are presented in a drop-down menu.

Option	Description
All	All results without filter.
Anytime	Everything with a timestamp. (Empty fields excluded)
Empty	Everything without a timestamp. (All the empty fields)
Before	Everything before the set date and time. (set time not included)
After	Everything after the set date and time. (set time included)
On	"On" means on that date, with that timezone so including 00:00 to 23:59 that day.