Template:BTD6 change list by name: Difference between revisions
made it so different changes from the same version are grouped together |
m fixed apostrophes |
||
| Line 1: | Line 1: | ||
<includeonly>{{autofill}}{{#cargo_query:table=btd6_changes | <includeonly>{{autofill}}{{#cargo_query:table=btd6_changes | ||
|fields=version, GROUP_CONCAT(quote)=quote, GROUP_CONCAT(changes SEPARATOR "\n")=changes | |fields=version, GROUP_CONCAT(quote)=quote, GROUP_CONCAT(changes SEPARATOR "\n")=changes | ||
|where=names HOLDS | |where=names HOLDS "{{{1|}}}" | ||
|order by=version | |order by=version | ||
|group by=version | |group by=version | ||
Revision as of 06:59, 28 November 2024
Uses Cargo to generate a list of changes that apply to a specific key.
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| Name | 1 | The key to use for the Cargo query. Will display a list of changes that contain this key in the "names" column with matching capitalization and spacing.
| String | required |
| Name 2 | 2 | A second key to use for querying. The results of both names will be shown in the list. | String | optional |
| Header level | header level | The level of section headers to use for the list.
| Number | optional |
| Before | before | Only shows changes from versions up to, but *not* including, this version number.
| Number | optional |
| since | since | Only shows changes from versions after, *and* including, this version number.
| Number | optional |
Example usage
{{BTD6 change list by name|Quincy}}
| This article or section uses Cargo to generate its content. It will automatically fill up as other articles are completed. To add to this section, create the articles it is looking up. Do not add content to this section manually and do not remove this notice until you are sure this section is complete. |
Function: CargoSQLQuery::run Query: SELECT `version` AS `version`,GROUP_CONCAT(quote) AS `quote`,GROUP_CONCAT(changes SEPARATOR "\n") AS `changes` FROM `cargo__btd6_changes` `btd6_changes` WHERE `btd6_changes`.`_ID` IN (SELECT `_rowID` FROM `cargo__btd6_changes__names` WHERE `_value`= "Quincy") GROUP BY `version` ORDER BY `version` LIMIT 100