Template:Implode characters with location: Difference between revisions

@@ Line 1: / Line 1: @@
-<includeonly>{{#ask:
+<includeonly>{{#ifexpr: {{#cargo_query:
-[[:+]]
+tables=characters
-{{#if: {{{1|}}} | [[Alignment::{{{1}}}]]   | }}
+|fields=COUNT(*)
-{{#if: {{{2|}}} | [[Affiliation::{{{2}}}]] | }}
+|where=characters.alignment = "{{{1}}}" and characters.status = "{{{3}}}" and characters.affiliation HOLDS "{{{2}}}" and characters.location = "{{{4}}}"
-{{#if: {{{3|}}} | [[Status::{{{3}}}]]     | }}
+|format=list
-{{#if: {{{4|}}} | [[Location::{{{4}}}]]     | }}
+}} | <table class="nowraplinks navbox-subgroup" style="border-spacing:0">{{#cargo_query:
-|format=ul}}</includeonly>
+tables=characters
+|fields=characters._pageName
+|where=characters.alignment = "{{{1}}}" and characters.status = "{{{3}}}" and characters.affiliation HOLDS "{{{2}}}" and characters.location = "{{{4}}}"
+|order by=characters.leader DESC, characters.name ASC
+|format=ul
+}}</table> | }}</includeonly>

Latest revision as of 18:08, 27 July 2024