Template:BTDB2 change list by name: Difference between revisions

@@ Line 1: / Line 1: @@
 <includeonly>{{autofill}}{{#cargo_query:table=btdb2_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, "]] ", IF(version_note != "", CONCAT("(", version_note, ")"), ""), "</h{{{header level|3}}}>\n",
-COALESCE(CONCAT("{", "{quote", "{{!}}", GROUP_CONCAT(quote), "{{!}}Update notes}", "}\n"), ""), GROUP_CONCAT(changes SEPARATOR "\n")) = a
+IF(GROUP_CONCAT(quote SEPARATOR "") != "", CONCAT("{", "{quote", "{{!}}", GROUP_CONCAT(quote SEPARATOR ""), "{{!}}Update notes}", "}\n"), ""), GROUP_CONCAT(changes ORDER BY priority SEPARATOR "\n")) = a
 |where=names HOLDS "{{{1|}}}"