Help:Cargo (Query): Difference between revisions

suggest merge
(Created page with "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...")
 
(suggest merge)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Merge|Help:Querying Cargo data|date=November 2024}}
This is a help article focused on querying [[cargo tables]] (part of the [[Help:Cargo|Cargo]] extension).
This is a help article focused on querying [[cargo tables]] (part of the [[Help:Cargo|Cargo]] extension).


Line 23: Line 25:


Example: Cities.Country=Countries._pageName
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


== Wikitext ==
== Wikitext ==
[[Category:Help]]
[[Category:Help]]