Filters

Modified on: Mon, 11 Oct, 2021 at 9:04 AM

Filters are a very powerful tool in N-OC Earth.

In basic filters work the the same way, but depending on which dataholder group the filter belong to, you have different expression options.

Name:	Mandatory
Period:	Valid From/to
Inherited:	Inherited from another filter. The conditions in this filter will be on top of the conditions in the inherited filter.
Groups:	If the filter only apply to some groups.
Sort Order:	Sort order can be important for some rules.
Active:	Yes/No
Default:	The filter will apply if no other filter exist.
Public:	The filter is open for edit.
Protected:	Only you can edit the filter
Private:	Only you can see and use the filter.

Filter Type:

We have two filter types Expression or Parameter.

Expression:

An Expression can consist of an Expression, Free text, logical AND, logical OR, parentheses ().

Select the one you want to use.

Legend:
=	equal
!=	not equal
>	greater than
<	less than
>=	greater than or equal
<=	lesser than or equal
String	text
Int	integer number
Text can be matched using Regex	.* means any character and .? means any single character.
FreeText	can be used to write custom filters, for example checking with current time 1. ValidFrom > DateTime.UtcNow.AddDays(-4) AND ValidFrom < DateTime.UtcNow.AddDays(4) 2. ValidFrom.Year == 2020 Or use it to check if a StringArray is populated at all 1. ProjectNames.Length > 0
Dynamic	To the left of the parameter you have a tick box "Dynamic".. When active, the system will ask you at run time which value the parameter shall have.