New article
Recently updated
Using Query Generator operators and aggregates
Who is this article for?Noise analysts who need a reference for Query Generator operators and aggregate options.
Access to the ANOMS Noise Analyst Workbench is required.
This reference lists the operators, aggregate options and join statements available when building criteria in the ANOMS Query Generator.
Understanding operators
An operator sets the condition that a value must meet for data to be extracted by the query. The following operators are available:
Operator | Typical use | Applies to |
Equal | Runway = 27R | Numerical and text data |
Not Equal | Runway <> 27R | Numerical and text data |
Greater Than | SEL > 80 | Numerical data |
Greater or Equal | SEL >= 80 | Numerical data |
Less Than | SEL < 80 | Numerical data |
Less or Equal | SEL <= 80 | Numerical data |
Between | Date Time Between 3/1/96 00:00:00 and 3/4/96 00:00:00 | Numerical data |
In (Including) | Runway In 27R,32L,4L — creates a list from the entries | Text data |
Not In | Runway Not In 27R,32L,4L — excludes the entries from the full listing | Text data |
Like | Aircraft Like B7% — finds all Boeing aircraft; use % to match any characters | Text data |
Not Like | Aircraft Not Like B7% | Text data |
Is Blank | Flight Number Is Blank — finds any record where the flight number was not filled in | Text data |
Is Not Blank | Flight Number Is Not Blank | Text data |
Today | Finds records from today | Date Time |
Last Day | Finds records from yesterday | Date Time |
Last Week | Finds records from the last week | Date Time |
Last Month | Finds records from the last month | Date Time |
Last Quarter | Finds records from the last quarter | Date Time |
Last Year | Finds records from last year | Date Time |
Selecting aggregate options
The aggregate is the basis of how the values in a field are queried. To select an aggregate option:
- Click the Aggregate option menu.
- Select one of the following options.
Term | Definition |
Value | Queries on the value of the field (for example, a noise level). |
Count | Queries on the number of times the field occurred (for example, find the hours during the day when the count of departures from a runway was greater than zero). |
Minimum | Queries on the minimum value of a numerical field. |
Maximum | Queries on the maximum value of a numerical field. |
Average | Queries on the average value of a numerical field. |
Sum | Queries on the sum of a numerical field. |
Value is used in almost all query statements. A matching set of aggregates is also available for the printed output — see the article Formatting Query Generator report output.
Using join statements and parentheses
Individual criteria statements are joined together by And or Or. Either And or Or must be selected for each statement after the first. Parentheses allow the grouping of statements.
Term | Definition |
And | Joins criteria statements so that both must be met to select a record (for example, flights that were departures and used runway 27). |
Or | Joins criteria statements so that only one of the criteria must be met (for example, flights from runway 32 or 27, but no other runways). |
For a worked example of Or with parentheses, see the article Query Generator example queries.