Help:Cargo (Query)

This is a help article focused on querying cargo tables (part of the Cargo extension).

Special page

Special:CargoQuery

Tables

Table(s) list one or more tables to query. Aliases for tables can be set as "TableName=Alias".

Example: Cities=city, Countries

Fields

Field(s) list fields to display. Default value is "_pageName". Aliases for fields can be set as "FieldName=Alias".

Example: Cities.Population=P, Countries.Capital

Where

Where allows you to enter condition(s). Multiple conditions can be separated by AND/OR.

Example: Country.Continent = 'North America' AND City.Population > 100000

Join on

Join on is mandatory when multiple tables are entered.

Example: Cities.Country=Countries._pageName

Group by

Group by combine rows with the same value for these field(s) into a single row.

Example: Countries.Continent

Order by

Order by list fields to sort query results.

Default value is _pageName ASC.

All options are:

• ASC
• DESC

Limit

Limit enter the maximum number of results to display.

Default value is 100.

Offset

Offset specify the number of rows to skip.

Default value is 0.

Format

Format set the format for displaying results.

Options include:

• Default
• list
  • Delimiter
• ul - Unordered list
  • Number of columns
• ol - Order list
  • Number of columns
• template
  • Template
  • Named args
  • Delimiter