{//% unless portal.user.is_agent %} Tickets
Welcome
Login Submit a Ticket News {//% endunless %}

Filters

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.
 
 
Location
Data Type
Aircraft:
 
Aircraft filters
Schedule
Human Resource:
 
Block filters
Block
Filters
Humanresources
Roster filters
Roster
Training filters
 
Schedule:
 
Leg filters
Company Activity
Slot Filters
 
 
 
 
 
 
 
 
 
 
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.
 
Expression type
Operation
Example
Boolean
false/true
String
text
StringArray
lookup in a list
Datetime
ddmmmyyhhmm
Time
HHMM
Int
Integer
 
    
 
 
 
Parameter:
 
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. 
 
Field
Data field name
Math Operator
Value
 
Logical Operator
And, Or, Not
 
 
 
Examples:
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
                

                                                    

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.