Template:BCS change list by name: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly> | <includeonly>{{#cargo_query:table=bcs_changes | ||
|fields=CONCAT("<h{{{header level|3}}}>[[", _pageName, "|Version ", version, "]] ", COALESCE(CONCAT("(", version_note, ")"), ""), "</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", "{{!}}", GROUP_CONCAT(quote), "{{!}}Update notes}", "}\n"), ""), GROUP_CONCAT(changes SEPARATOR "\n")) = a | COALESCE(CONCAT("{", "{quote", "{{!}}", GROUP_CONCAT(quote), "{{!}}Update notes}", "}\n"), ""), GROUP_CONCAT(changes SEPARATOR "\n")) = a | ||
Revision as of 20:16, 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}}
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