Template:BCS change list by name: Difference between revisions
Created page with "<includeonly>{{#cargo_query:table=bcs_changes |fields=version, quote, changes |where=name='{{{1|}}}' |order by=version |format=template |template=BCS change list row |named args=yes |delimiter=\n }}</includeonly><noinclude>{{/doc}}Category:Cargo query templatesCategory:BCS templates</noinclude>" |
No edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>{{#cargo_query:table=bcs_changes | <includeonly>{{#cargo_query:table=bcs_changes | ||
|fields=version, quote, changes | |fields=CONCAT("<h{{{header level|3}}}>[[Bloons Card Storm v", version, "|Version ", version, "]]</h{{{header level|3}}}>\n", | ||
|where= | COALESCE(CONCAT("{", "{quote", "{{!}}", quote, "{{!}}Version ", version, " update notes}", "}\n"), ""), changes) | ||
|where=names HOLDS "{{{1|}}}" | |||
|order by=version | |order by=version | ||
|format= | |format=list | ||
|delimiter=\n | |delimiter=\n | ||
}}</includeonly><noinclude>{{/doc}}[[Category:Cargo query templates]][[Category:BCS templates]]</noinclude> | }}</includeonly><noinclude>{{/doc}}[[Category:Cargo query templates]][[Category:BCS templates]]</noinclude> | ||
Revision as of 05:47, 20 October 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 `bcs_changes`.`_pageID` AS `cargo_backlink_page_id_bcs_changes`,CONCAT("<h3>Version ", version, "</h3>\n", COALESCE(CONCAT("{", "{quote", "|", quote, "|Version ", version, " update notes}", "}\n"), ""), changes) AS `CONCAT( <h3>Version , version, </h3>\n , COALESCE(CONCAT( { , {quote , | , quote, |Version , version, update notes} , }\n ), ), changes)` FROM `cargo__bcs_changes` `bcs_changes` WHERE `bcs_changes`.`_ID` IN (SELECT `_rowID` FROM `cargo__bcs_changes__names` WHERE `_value`= "Quick Ready") ORDER BY `version` LIMIT 100