Template:Creature navbox query: Difference between revisions

Latest revision as of 19:02, 26 December 2021

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

argument	value	returns
2	common	returns all common creatures (not unique)
2	unique	returns all unique creatures
category	<Category Name>	returns all creatures in the specified category
notcategory	<Category Name>	returns all creatures NOT in the specified category

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

@@ Line 1: / Line 1: @@
 <includeonly><span style="display:inline-block">{{#invoke:CargoQuery| main
 |q?tables=CreatureFactions=CF,GeneralData=GD,ExtraInfo=EI
-|q?join=CF._pageName=GD._pageName, CF._pageName=EI._pageName
+|q?join=CF.ObjectID=GD.ObjectID, CF.ObjectID=EI.ObjectID
-|q?fields=GD.ObjectID=Page
+|q?fields={{favilink format args}}
-|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,%"|}}{{#if:{{{category|}}}|AND GD.Categories = '{{{category}}}'}}{{#if:{{{notcategory|}}}|AND (GD.Categories IS NULL OR GD.Categories <> '{{{notcategory}}}')}}
+|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,%"|}} {{#if:{{{category|}}}|AND GD.Categories = '{{{category}}}'}}{{#if:{{{notcategory|}}}|AND (GD.Categories IS NULL OR GD.Categories <> '{{{notcategory}}}')}} AND GD.Categories <> 'Pets'
 |q?groupBy=GD.ObjectID
-|template=favilink id
+|template=favilink format
 |delimiter=&nbsp;-&#160;</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.