Query operators

When you create a query, you can use the operators listed below. Selecting an operator is optional. If you do not select an operator, the data set will be returned untouched.

Available operators:

• Aggregate

• Column manipulations

• Custom operator

  Note

  From DataMiner 10.2.7 to 10.4.1 and 10.3.0 to 10.3.0 [CU10], the custom operator is available in soft launch.

• Filter

• Join

• Select

• (Then) Sort (by)

• Top X

From DataMiner 10.4.0 [CU13]/10.5.0 [CU1]/10.5.4 onwards, you can rearrange the operators that have been added in a query by dragging and dropping them to a different position on the same level. If an operator turns red after being moved, this indicates that it cannot be used at that location and the query has become invalid.

Note

• Some operators can make use of data. From DataMiner 10.3.5/10.4.0 onwards, a link icon is displayed to the right of a selection box if using data is possible. Click this icon to select the data. In earlier DataMiner versions, a Use feed checkbox is available for this instead.
• The Then sort by operator is a child node of the Sort by operator, so if you move a Sort by node, all its Then sort by child nodes will move with it.