Template:BTDB2 change list by name: Difference between revisions

mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly>{{autofill}}{{#cargo_query:table=btdb2_changes
<includeonly>{{autofill}}{{#cargo_query:table=btdb2_changes
|fields=CONCAT("<h{{{header level|3}}}>[[", _pageName, "|Version ", version, "]] ", IF(version_note != "", CONCAT("(", version_note, ")"), ""), "</h{{{header level|3}}}>\n",
|fields=CONCAT("<h{{{header level|3}}}>[[", _pageName, "|Version ", version, "]] ", IF(version_note != "", CONCAT("(", version_note, ")"), ""), "</h{{{header level|3}}}>\n",
GROUP_CONCAT(CONCAT(IF(quote != "", CONCAT("{", "{quote", "{{!}}", quote, "{{!}}Update notes}", "}\n"), ""), "\n", changes) ORDER BY priority, changes DESC SEPARATOR "\n")) = a
GROUP_CONCAT(CONCAT(IF(quote != "", CONCAT("{", "{quote", "{{!}}", quote, "{{!}}Update notes}", "}\n"), ""), "\n", changes) ORDER BY priority DESC, changes SEPARATOR "\n")) = a


|where=names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR names HOLDS "{{{2|}}}"}}
|where=names HOLDS "{{{1|}}}"{{#if:{{{2|}}}| OR names HOLDS "{{{2|}}}"}}