Template:Creature navbox query: Difference between revisions

Revision as of 15:55, 10 September 2019

A query that returns all creatures favilinked within a faction, delimited by hyphens. First argument must be the faction name.

second argument	returns
common	returns all common creatures (not unique)
unique	returns all unique creatures

By default, all creatures will be returned together regardless of unique status.

@@ Line 1: / Line 1: @@
-<includeonly><span style="display:inline-block">{{#invoke:CargoQuery| main |q?tables=CreatureFactions,GeneralData
+<includeonly><span style="display:inline-block">{{#invoke:CargoQuery| main
-|q?join=CreatureFactions._pageName=GeneralData._pageName|q?fields=PlainName=Page
+|q?tables=CreatureFactions=CF,GeneralData=GD,ExtraInfo=EI
-|q?where=Faction="{{{1|Crabs}}}" AND CreatureFactions._pageNamespace ='0'
+|q?join=CF._pageName=GD._pageName, CF._pageName=EI._pageName
-|q?orderBy=CreatureFactions._pageName
+|q?fields=GD.PlainName=Page
-|q?groupBy=CreatureFactions._pageName
+|q?where=Faction='{{#replace:{{{1|}}}|'|\'}}' AND GD._pageNamespace ='0' {{#switch:{{{2|_NULL_}}}|common= AND (EI.Info NOT LIKE "%Unique,%" OR EI.Info IS NULL)|unique= AND EI.Info LIKE "%Unique,%"|}}
 |template=favilink
-|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span></includeonly><noinclude>[[Category:Query Templates]]</noinclude>
+|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span></includeonly><noinclude>[[Category:Query Templates]]
+A query that returns all creatures favilinked within a faction, delimited by hyphens. First argument must be the faction name.
+{|class="wikitable"
+!second argument
+!returns
+|-
+!common
+|returns all common creatures (not unique)
+|-
+!unique
+|returns all unique creatures
+|}
+By default, all creatures will be returned together regardless of unique status.
+</noinclude>