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
• embedded
• cvs
  • Delimitter
  • Link text
  • Filename
  • Parse value (check box)
• Excel
  • Filename
  • Link text
  • Parse value (check box)
• feed
  • Options
    • atom
    • rss
  • Link text
  • Feed title
  • Feed description
• json
  • Parse value (check box)
• Outline
  • Outline fields
• Tree
  • Parent field
• Table
  • Merge similar cells (check box)
  • Edit link (check box)
• Dynamic table
  • Rows per page
  • Details fields
  • Hidden fields
  • Column widths
  • Header tooltips
• map
  • Height
  • Width
  • Icon
  • Zoom
• googlemaps
  • Height
  • Width
  • Icon
  • Zoom
  • Center
  • Cluster
• leaflet
  • Height
  • Width
  • Icon
  • Zoom
  • Center
  • Cluster
  • Image
• openlayers
  • Height
  • Width
  • Icon
  • Zoom
  • Center
  • Cluster
• calendar
  • Height
  • Width
  • Start date
  • Color
  • Text color
• icalendar
  • Link text
  • Filename
  • icalendar name
  • icalendar description

• timeline
  • Height
  • Width
• gantt
  • Height
  • Width
  • Columns
• bpmn
  • Height
  • Width
• category
• bar chart
  • Height
  • Width
• pie chart
  • Height
  • Width
  • Colors
  • Hide legend (check box)
• gallery
  • Mode
    • traditional
    • nolines
    • packed
    • packed-overlay
    • packed-hover
  • Show bytes (check box)
  • Show filename (check box)
  • Show dimensions (check box)
  • Per row
  • Image width
  • Image height
• slideshow
  • Caption field
  • Link field
  • Slides per screen
• tag cloud
  • Template
  • Min size
  • Max size
• exhibit
  • View
    • map
    • tabular
    • timeline
  • Facets
  • Datalabel
  • End
  • Color
  • Topunit
    • millisecond
    • second
    • minute
    • hour
    • day
    • week
    • month
    • year
    • decade
    • century
    • millennium
  • Toppx
  • Bottompx
• bibtex
  • Default entry type
  • Link text
• zip
  • Filename
  • Link text