Skip to content
Console(opens in a new tab)

Selection

The fields you ask to have back.

What do I want to know about them?

The fields you ask to have back. Nothing arrives that you did not name. A number is a selection too: count, sum and the other math fields stand where a list of rows would stand.

Every record answers these fields. Each one computes a number or a date over one of the record’s connections.

Field Arguments Returns Description
count field: String!, conditions: Conditions Int Counts the related items at the field path, such as operatingLocations. If the path ends at a field, it counts the values of that field that are not null. It returns 0 when nothing matches.
countDistinct field: String!, conditions: Conditions Int Counts the distinct values at the field path. If the path ends at a relationship, it counts the distinct related items. It returns 0 when nothing matches.
has field: String!, conditions: Conditions Boolean Returns true when at least one related item exists at the field path, after conditions apply.
sum field: String!, conditions: Conditions Int Adds up the values at the field path across the related items. It returns 0 when nothing matches.
min field: String!, conditions: Conditions Int Returns the smallest value at the field path across the related items.
max field: String!, conditions: Conditions Int Returns the largest value at the field path across the related items.
avg field: String!, conditions: Conditions Float Returns the average of the values at the field path across the related items.
collect field: String!, separator: String, conditions: Conditions String Joins the values at the field path into one string, with separator between them. The path must be one relationship and one field, and the default separator is ;. This field works only in a search with output.
minDateTime field: String!, conditions: Conditions DateTime Returns the earliest date and time at the field path across the related items.
maxDateTime field: String!, conditions: Conditions DateTime Returns the latest date and time at the field path across the related items.