Filters | Knowledge Base

^{Last Updated:}^2026-01-12

Purpose

This article 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.

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.
,	Boolean AND (comma) a,b	Provides results that contain both or all keywords. Example: a,b => a AND b
\|	Boolean OR (pipe) a\|b	Provides results that contain either keyword. Example: a\|b => a OR b Combinations can be done: a,b\|c => (a AND b) OR c a,b\|c,b => (a AND b) OR (c AND b)

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

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.

Boolean AND (comma)

a,b

Provides results that contain both or all keywords.

Example: a,b => a AND b

Boolean OR (pipe)

a|b

Provides results that contain either keyword.

Example: a|b => a OR b

Combinations can be done:

a,b|c => (a AND b) OR c

a,b|c,b => (a AND b) OR (c AND b)

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 separate widget.

Filter Modes

The date filter provides three modes accessible via tabs at the top of the filter panel:

Quick

Predefined common date ranges for fast filtering:

Option	Description
All	All results without filter. No date filtering is applied.
Today	Everything since 00:00 in the selected time zone.
Yesterday	Everything since 00:00 until 23:59:59 the day before in the selected time zone.
Last week	Everything in previous week since 00:00 in the selected time zone until the last day of week at 23:59:59. The week starts on Monday and ends with Sunday.
Last month	Everything in the previous month from the 1st of the month at 00:00 in the selected time zone until 23:59:59 of the last day of the month.
Last 24 hours	Everything since exactly 24 hours back in the selected time zone.
Last 7 days	All data from exactly 7 days ago at the current time up to now, based on the selected time zone.
Last 30 days	All data from exactly 30 days ago at the current time up to now, based on the selected time zone.
Has date	Everything with a timestamp. Empty fields are excluded from results.
No date	Everything without a timestamp. Only returns rows where the date field is empty/null.

Quick filters are dynamic and update relative to the current date and time.

Relative

Dynamic time period filters that remain relative to the current date/time and automatically update.

Configuration options:

Option	Description
On	On that specific period with the selected timezone. Amount: Numeric value Unit: seconds, minutes, hours, days, weeks, months, or years Direction: "ago" (past) or "from now" (future) Rounding: Always enabled for "On" filters The filter creates a full period boundary. For example: "2 days ago" returns the entire day from 2 days ago (00:00:00 to 23:59:59) "1 week ago" returns Monday 00:00:00 through Sunday 23:59:59 of that week "3 months ago" returns the 1st through the last day of that month This allows filtering on complete time units relative to the current date/time. Visualization:
Before	Everything before the set relative date and time. The specified time is not included in the results. Amount: Numeric value (e.g., 1, 2, 10) Unit: seconds, minutes, hours, days, weeks, months, or years Direction: "ago" (past) or "from now" (future) Rounding: Optional checkbox to align to unit boundary (e.g., "1 day ago" rounded = start of that day at 00:00) Example: "3 days ago" with rounding returns everything before 3 days ago at 00:00:00. Visualisation:
After	Everything after the set relative date and time. The specified time is included in the results. Amount: Numeric value (e.g., 1, 2, 10) Unit: seconds, minutes, hours, days, weeks, months, or years Direction: "ago" (past) or "from now" (future) Rounding: Optional checkbox to align to unit boundary Example: "2 weeks ago" returns everything from 2 weeks ago on. Matches future time too. With rounding enabled, it starts from the beginning of the week (Monday 00:00) from 2 weeks ago.
Between	Everything between two date/time boundaries, inclusive of both start and end times. From: Amount, unit (seconds/minutes/hours/days/weeks/months/years), and direction To: Separate amount, unit, and direction configuration Rounding: Optional checkbox applies rounding to both boundaries Each boundary is calculated independently, allowing flexible ranges like "2 days ago to 1 week from now" or "1 month ago to 5 days ago". Example: "Between 7 days ago and 1 day ago" with rounding returns everything from Monday 00:00:00 of last week through 00:00:00 of yesterday. Visualization:

Filter Selection Priority

When opening the date filter panel, the widget automatically selects the most appropriate filter option based on your current selection. If your selected date range matches multiple filter types, the widget follows this priority order:

Quick filters (Today, Yesterday, This Week, Last Week, etc.)
Relative date filters (for example, "1 day ago", "2 weeks ago")
Absolute date filters (specific calendar dates)

Example: If you select "1 day ago" in the relative date filter, which matches the "Yesterday" quick filter, the widget will display "Yesterday" as the selected option when you reopen the date panel. The widget prioritizes showing the simpler quick filter option rather than the relative date configuration you originally selected.

This behavior also applies when:

Loading saved view templates
Refreshing the page with filters in the URL
Switching between different views
Reopening the widget for the same column

The widget always tries to display your filter using the simplest matching option from the highest priority category available.

Fields description

Amount: Positive integer specifying the quantity of time units
Unit: Time unit selector with options:
- seconds
- minutes
- hours
- days
- weeks
- months
- years
Direction:
- "ago" - in the past (creates negative ISO 8601 periods like -P2D)
- "from now" - in the future (creates positive ISO 8601 periods like P1W)
Rounding: Optional checkbox to align timestamps to unit boundaries:
- second: :00.000 milliseconds
- minute: :00 seconds
- hour: :00:00 (top of hour)
- day: 00:00:00 (midnight)
- week: Monday 00:00:00
- month: 1st day at 00:00:00
- year: January 1st at 00:00:00

Technical format: Relative filters are stored as ISO 8601 durations (e.g., -P2D = 2 days ago, P1W = 1 week from now, -P3M = 3 months ago).

Live preview: The filter displays a "Currently:" hint showing the calculated date/time in the selected timezone with the current configuration.

Absolute

Specific fixed timestamps that do not change over time.

When selecting a date in the filters, a date picker is displayed showing the calendar interface with the selected timezone at the top.

Date picker: Calendar based interface for selecting exact dates and times. Timestamps are stored with timezone offset information (e.g., 2025-11-18T10:00+01:00).

Use cases: Best for historical queries, compliance reporting, or filtering on specific known dates that should not shift over time.

Option	Description
On	Selects a specific date. Returns everything from 00:00:00 to 23:59:59 on that date in the selected timezone. Example: Selecting March 15, 2026 returns all records from March 15, 2026 at 00:00:00 through 23:59:59 in your timezone.
Before	Returns everything before the specified date and time. The specified time is not included in the results. Example: Selecting March 15, 2026 at 14:30 returns all records before March 15, 2026 at 14:30 in the selected timezone.
After	Returns everything after and including the specified date and time. The specified time is included in the results. Example: Selecting March 15, 2026 at 14:30 returns all records from March 15, 2026 at 14:30 onwards in the selected timezone.
Between	Returns everything between two date/time boundaries, inclusive of both start and end times. Example: Selecting March 1 to March 31 returns all records from March 1 at 00:00:00 through March 31 at 23:59:59 in the selected timezone.

Timezone Handling

All date filters include timezone support via an autocomplete field at the top of the filter panel.

Timezone format: Filters store timezone information:
- Relative/Quick filters: |timezone(timezone_name) suffix (e.g., >-P1D|timezone(Europe/Stockholm))
- Absolute filters: +HH:MM offset appended to timestamps (e.g., 2025-11-18T10:00+01:00)
Timezone display: Shows timezone name and UTC offset (e.g., "Europe/Stockholm (UTC+02:00)")
Filter interpretation: All date comparisons are performed in the selected timezone, ensuring consistent results regardless of server or client timezone settings

Technical Details

Stored format examples:

Quick filter: >-P1D|timezone(Etc/UTC) (after today)
Relative "On": -P2D|timezone(Europe/Stockholm)|round (on the day 2 days ago, rounded)
Relative "Before": <-P1W|timezone(America/New_York) (before 1 week ago)
Relative "Between": -P7D•-P1D|timezone(Asia/Tokyo)|round (between 7 days ago and 1 day ago, both rounded)
Absolute "On": 2025-11-18T00:00+01:00
Absolute "Between": 2025-11-01T10:00+01:00•2025-11-30T18:00+01:00

Filter modifier suffixes:

|timezone(name): Specifies the timezone for relative/quick filters
|round: Indicates rounding is enabled for relative filters
+HH:MM or -HH:MM: Timezone offset for absolute timestamp filters

Column Filters

Filters can be applied directly in the column head.

Clearing Filters

The × icon next to the search field restores the search phrase and lists all columns unfiltered.

The clear filter icon to the top right clears all of the filters applied to the table. Clicking the X on a specific filter removes that filter only.

Filters can also be cleared using the clear filter icon at the bottom left of the view.