Filters are a very powerful tool in N-OC Desktop. Filters in Desktop work the same as in Web. Depending on which dataholder group the filter belongs to, you have different expression options. Each filter group has a separate icon.
The image below shows the different filters available when you searched:
Categorization of Filters | Filter Types | Data Type |
| Aircraft | Aircraft Filters | Schedule |
| Human Resource | Block Filters | Block |
| Human Resource | Filters | Humanresources |
| Human Resource | Roster Filters | Roster |
| Human Resource | Training filters | |
| Schedule | Leg Filters | Company Activity |
| Schedule | Sort Filters |
Field | Description |
| Name | This is a mandatory field. Enter the filter's name. |
| Period | When is the filter valid from and 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 applies to some User Groups. |
| Sort | If the filter only applies to some groups. This refer to the order the filters will appear in the dropdown boxes. |
| Active | If checked, the filter is active. |
| Default | The filter will apply if no other filter exists. |
| Permissions | Public: The filter is open for edit. The filter can be edited by anyone that has user right to edit filters. Protected: Only you can edit the filter. It can be seen and used by any users that have user rights to view filters. Private: Only you can see and use the filter. |
Filter Types
We have two filter types:
- Expression - An Expression can consist of an Expression, Free Text, logical AND, Logical OR, and parentheses ( ).
- Parameter - This is a more sophisticated way of building filters. The field box doesn't indicate the type of field.
Expression
Legend | Description |
= | 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 | It can be used to write custom filters. For example, checking with the current time:
|
Expression type | Operation | Example |
| Boolean | False/true |  |
| String | Text |  |
| StringArray | Look up in a list |  |
| Datetime | ddmmmyyhhmm |  |
| Time | HHMM |  |
| Int | Integer |  |
Parameter
Note: You have the Logical Operator NOT.
Field | Expression |
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 the PHX base.
Test Function
The Test Function is used to ensure that the syntax of the filter is correct. It is helpful to verify that the filter is set up to produce the results expected.