Template:Query/Advanced/doc

Function
This template can be used to query entries from Cargo tables as a slightly faster shorthand than generating the query manually. It is more flexible than the existing Query template, which is more suited for simple queries. However, it is less flexible than the CargoQuery parent template, but has more automatic fill-ins for general use.

It can also be abbreviated by using the AQ template redirect instead of Query/Advanced.

Parameters
Most parameters are identical to the full Cargo query invocation.

Mandatory Parameters

 * - Specifies which Cargo tables to pull data from. If more than one table is specified, a join must be used.

Data

 * - Specifies which columns to pull data from. If none are specified, it will pull all columns.
 * - Specifies which tables to be joined. Omitted if only a single table is queried.
 * - Specifies conditions for data to be returned. Will return all values otherwise.
 * - Specifies the maximum amount of rows to be returned. Defaults at 250.

Aggregation

 * - Specifies how entries containing similar value type in a column should be grouped.

Styling

 * - Specifies how entries should be ordered, whether ascending or descending.
 * - Specifies which template should be used. Work in progress, limited to thumb, inline and list. Defaults to list.
 * - Specifies how the header should appear.
 * - Specifies how the footer should appear.
 * - Specifies the message to appear if no results are returned. Defaults to "No TABLE NAME HERE available".

Querying the First 3 Spells
Click to expand result

Querying Spells With the Name LIKE Thunder
Click to expand result

Querying Beings With the Name of Chest
Click to expand result

Querying Beings With the Name of Chest, as Thumbnails
Click to expand result

Querying Beings With the Name of Chest, as Inline Icons
Click to expand result