Template:BCS change list by name: Difference between revisions

From Blooncyclopedia, the independent Bloons knowledge base
Jump to navigation Jump to search
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, "{{!}}Version ", version, " update notes}", "}\n"), ""), changes)
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}}[[Category:Cargo query templates]][[Category:BCS templates]]</noinclude>
}}</includeonly><noinclude>{{/doc}}</noinclude>

Revision as of 01:54, 3 December 2024

No description.

Template parameters[Edit template data]

This template prefers inline formatting of parameters.

ParameterDescriptionTypeStatus
Name 11

no description

Unknownoptional
Name 22

no description

Unknownoptional
Name 33

no description

Unknownoptional
Beforebefore

Only shows changes from versions up to, but *not* including, this version number.

Numberoptional
Sincesince

Only shows changes from versions after, *and* including, this version number.

Numberoptional
Header levelheader level

no description

Numberoptional

Example usage

{{BCS change list by name|Quick Ready}}
Icon of "the greatest challenge" 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.
Error 1054: Unknown column 'quote' in 'field list'

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