Changelog

QUERY

Querying an AirData App Object returns the App Object instances that fit the query parameters.

Query Properties

App Object

Expects type object.

Sets which AirData App Object will be queried

Paginate Type

If Limit Offset is selected, limits the number of rows returned from a query and omit a specified number of rows.

Paginate Limit

  • type: int

  • description: Limit the number of pages to return in a query

Paginate Offset

  • type: int

  • default: 0

  • description: Depth into the result set to return

Query Limit

  • type: int

  • default: 100

  • description: Maximum number of results to return in a given page

Data can be queried using the Visual Query Builder as well as the Expression Editor.

Visual Query Builder

Visual Query Builder provides a visual representation of grouping and querying data in AirData.

The query can either be an AND query or an OR query. AND will query all records if all group conditions are TRUE. OR will display records if any of the group conditions are TRUE

When Adding groups, fields can be combined to create more precise filters. For example, the image below represents a query that will return all records where the score = 10 AND returning_customer = true OR score > 8..

Expression Editor

The Expression Editor allows you to use Airscript to filter the data returned by AirData queries. Queries consist of the following components:

filterKeyWord: the primary name for the filter.

type: the Airkit data type of the field that you wish to query (text, list of texts, etc)

aliases: can be used to clarify the intent of or shorten your query using different filter key words.

For example, the following queries will operate identically:

{ "age": { "<": 2 } }
{ "age": { "lessThan": 2 } }

example query: A valid sample query based on the example datastore.

query returns: A description of what the sample query would return from example datastore.

String matching filters

Filter
Description
Aliases
Type
Example

anyOf

strict equality test

=, in, any, eq

T | Collection where T = type of field

{ "breed": { "anyOf": ["mutt" , "pug"] } } All dogs exactly matching the string "mutt" or "pug" in the "breed" field.

insensitiveAnyOf

when T is Text, case-insensitive equality; when T is List, unordered equality; otherwise defaults to anyOf behavior

~=, ieq, iEquals, insensitiveEquals, iAnyOf

T | Collection where T = type of field

{ "name": { "insensitiveAnyOf": ["DAISY" , "PENNY"] } } All dogs with names matching the string "daisy" or "penny" regardless of capitalization.

noneOf

strict inequality test

!=, not, none, neq, !eq

T | Collection where T = type of field

{ "owner": { "noneOf": ["Damon", "Jeff"] } } All dogs who have an owner that is NOT "Damon" or "Jeff".

like

string contains, only works on text fields

like

T | Collection where T = type of field

{ "name": { "like": "y" } } Any dog that has the character "y" in their name.

Quantitative filters

Filter
Description
Alias
Type
Example

lessThan

less than, exclusive

<, lt

T where T = type of field

{ "age": { "lessThan": "5" } } All dogs who are less than 5 years old.

lessThanOrEqual

less than, inclusive

<=, lte

T where T = type of field

{ "age": { "lessThanOrEqual": "5" } } All dogs who are strictly younger than 5 years old.

greaterThan

greater than, exclusive

>, gt

T where T = type of field

{ "age": { "greaterThan": "2" } } All dogs who are strictly older than 2 years.

greaterThanOrEqual

greater than, inclusive

>=, gte

T where T = type of field

{ "age": { "greaterThanOrEqual": "10" } } All dogs who are at least 10 years old or older.

List/set filters

Filter
Description
Alias
Type
Example

intersects

matches where any of the elements in the filter also exist in the list

∩, intersect, intersection, intersectionOf

Set where T = type of element type in List * field type must be List

{ "nicknames": { "intersects": [ "dog", "doggy", "Lulu", "doesn’t matter" ] } } Any entry that has a nickname in the searched array. In our example, it returns entries 2,3,6 & 7.

supersetOf

matches where the field is a superset of any of the provided sets

⊇, superset, overlap, overlaps, overlapsAny, supersetOfAny

Set

Set<Set> where T = type of element type in List * field type must be List

subsetOf

matches where the field is a subset of any of the provided sets

⊆, subset, overlapped, subsetOfAny, overlappedBy

Set

Set<Set> where T = type of element type in List * field type must be List

containsAnyOf

if field is list, matches if any element in this set exists in the field if text, matches if any of the strings are a substring of the field

∈, containsAny

Set

Text where T = type of element type in List * field type must be List

containsAllOf

if field is list, matches if all elements in this set exist in the field if text, matches if all of the strings are a substring of the field

containsAll

Set

Text where T = type of element type in List * field type must be List

containsNoneOf

if field is list, matches if none of the elements in this set exist in the field if text, matches if none of the strings are a substring of the field

∉, containsNone

Set

Text where T = type of element type in List * field type must be List

Sorting data

In order to sort data from Airdata, add a Transform Data Operation downstream of the AirData Request and use a Query Expression to reorder the returned data.

Examples

You can use Airscript to further refine your AirData queries. For example:

{ "dogName": { "anyOf": "{{ LOWERCASE("LUCY")}}" } }

You can combine multiple queries to specify your search.

{ "dogName": { "insensitiveAnyOf": "daisy" }, "dogAge": { "greaterThan": 4 } }

📘 Note: Comma delimited queries function as an AND operation, not OR.

PreviousPATCHNextDEPRECATED_QUERY

Last updated

Was this helpful?