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 | | |