Template:BCS change list by name: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>{{#cargo_query:table=bcs_changes | <includeonly>{{autofill}}{{#cargo_query:table=bcs_changes | ||
|fields=CONCAT("<h{{{header level|3}}}>[[", _pageName, "|Version ", version, "]]</h{{{header level|3}}}>\n", | |fields=CONCAT("<h{{{header level|3}}}>[[", _pageName, "|Version ", version, "]] ", COALESCE(CONCAT("(", version_note, ")"), ""), "</h{{{header level|3}}}>\n", | ||
COALESCE(CONCAT("{", "{quote", "{{!}}", quote, "{{!}} | COALESCE(CONCAT("{", "{quote", "{{!}}", GROUP_CONCAT(quote), "{{!}}Update notes}", "}\n"), ""), GROUP_CONCAT(changes SEPARATOR "\n")) = a | ||
|where=names HOLDS "{{{1|}}}" | |where=names HOLDS "{{{1|}}}" | ||
|order by=version | |order by=version | ||
|group by=_pageName, version | |group by=_pageName, version, version_note | ||
|format=list | |format=list | ||
|delimiter=\n | |delimiter=\n | ||
|default=No changes found. | |default=No changes found. | ||
}}</includeonly><noinclude>{{/doc}} | }}</includeonly><noinclude>{{/doc}}</noinclude> | ||
Revision as of 01:54, 3 December 2024
No description.
| Parameter | Description | Type | Status | |
|---|---|---|---|---|
| Name 1 | 1 | no description | Unknown | optional |
| Name 2 | 2 | no description | Unknown | optional |
| Name 3 | 3 | no description | Unknown | 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 |
| Header level | header level | no description | Number | optional |
Example usage
{{BCS change list by name|Quick Ready}}
| 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 CONCAT("<h3>Version ", version, " ", COALESCE(CONCAT("(", version_note, ")"), ""), "</h3>\n", COALESCE(CONCAT("{", "{quote", "|", GROUP_CONCAT(quote), "|Update notes}", "}\n"), ""), GROUP_CONCAT(changes SEPARATOR "\n")) AS `a` FROM `cargo__bcs_changes` `bcs_changes` WHERE `bcs_changes`.`_ID` IN (SELECT `_rowID` FROM `cargo__bcs_changes__names` WHERE `_value`= "Quick Ready") GROUP BY _pageName, version, version_note ORDER BY `version` LIMIT 100