Cargo query

Table(s):More information List one or more tables to query. Aliases for tables can be set as "TableName=Alias". Example: Cities=city, Countries
Field(s):More information List fields to display. Default value is "_pageName". Aliases for fields can be set as "FieldName=Alias". Example: Cities.Population=P, Countries.Capital
Where:More information Enter condition(s). Multiple conditions can be separated by AND/OR. Example: Country.Continent = 'North America' AND City.Population > 100000
Join on:More information Mandatory when multiple tables are entered. Example: Cities.Country=Countries._pageName
Group by:More information Combine rows with the same value for these field(s) into a single row. Example: Countries.Continent
Having:More information Enter condition(s) to only return rows with certain aggregate values. Example: COUNT(*) > 10
Order by:More information List fields to sort query results. Default value is _pageName ASC.
Limit:More information Enter the maximum number of results to display. Default value is 100.
Offset:More information Specify the number of rows to skip. Default value is 0.
Format: More information Set the format for displaying results.

Anonymous