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.
Inherited from another filter. The conditions in this filter will be on top of the conditions in the inherited filter.
If the filter only apply to some groups.
Sort order can be important for some rules.
The filter will apply if no other filter exist.
The filter is open for edit.
Only you can edit the filter
Only you can see and use the filter.
We have two filter types Expression or Parameter.
An Expression can consist of an Expression, Free text, logical AND, logical OR, parentheses ().
Select the one you want to use.
greater than or equal
lesser than or equal
Text can be matched using Regex
.* means any character
and .? means any single character.
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
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.
lookup in a list
This is a more sophisticated way of building filters. The field box doesn't indicate the type the field.
Note that you have the Logical Operator NOT.
Data field name
And, Or, Not
Find crew assigned to a reference activity of group "MM" and with Roster designator "I" or "N".
Find assigned Deadhead crew on airline UA in flight number range
Find active flight attendants from base PHX