Teltura: Created page with "This template is a Battlegrounds version of {{t|List cards}} that returns only Battlegrounds minions. ==Usage==

{{CardQuery  |layout=  |where=  |orderBy=  |co..."

2022-01-20T08:12:43Z

Created page with "<noinclude>This template is a Battlegrounds version of {{t|List cards}} that returns only Battlegrounds minions. ==Usage== <pre>{{CardQuery |layout= |where= |orderBy= |co..."

New page

<noinclude>This template is a Battlegrounds version of {{t|List cards}} that returns only Battlegrounds minions.

==Usage==
<pre>{{CardQuery
|layout=
|where=
|orderBy=
|collapsed=
|limit=
|offset=
}}</pre>

==Parameters==
*<code>layout</code>: Choose one of these layouts: table, image, table golden, image golden, or count. Default is table.
*<code>where</code>: Where clauses, pretty much like SQL functions. Default is <code>{{t|Bg buyable}}</code>, which means to search all minions available in Bob's Tavern.
*<code>orderBy</code>: Order to sort the results. Default is <code>techLevel ASC, name ASC</code>.
*<code>collapsed</code>: If true (default), the table/card image list will be collapsed after the page is reloaded, and vice versa if false.
*<code>limit</code>: Maximum number of cards to display. If the limit number and the results number are too high, it will display error: "The time allocated for running scripts has expired." Default is 500.
*<code>offset</code>: the number of initial cards to skip. This combines with <code>limit</code> for separating lists whose the number of results are very high into individual pages/articles.

===Where clauses===
Here are some examples of where clauses you can use:
*<b>Returns tavern minions (or buyable minions)</b>
**<code><nowiki>({{Bg buyable}})</nowiki></code>
*<b>Returns Elemental pool</b>
**<code><nowiki>({{Cards tb|race}}="{{Minion type returns|Elemental}}" OR {{Cards tb|tags}}__full LIKE "%Elemental-related%")</nowiki></code>
**<code><nowiki>({{Cards tb|race}}="ELEMENTAL" OR {{Cards tb|tags}}__full LIKE "%Elemental-related%")</nowiki></code>
**<code><nowiki>({{Bg minion pool|Elemental}})</nowiki></code>
*<b>Returns General minions</b>
**<code>({{Cards tb|race}} IS NULL)</code>
There are also available templates of where clauses:
*{{t|Bg buyable}}
*{{t|Bg general pool}}
*{{t|Bg minion pool|<id, name or renderName of minion type>}}

==Examples==
<code><nowiki>{{List cards bg minions|layout=table|where={{Bg buyable}}|orderBy={{Cards tb|techLevel}} ASC, {{Cards tb|name}} ASC}}</nowiki></code> returns:
<code><nowiki>{{List cards bg minions|layout=image|where={{Cards tb|race}}="{{Minion type returns|Beast}}" AND Cards.customCycles HOLDS "BG tavern token"|orderBy={{Cards tb|techLevel}} ASC, {{Cards tb|name}} ASC}}</nowiki></code> returns: {{List cards bg minions|layout=image|where={{Cards tb|race}}="{{Minion type returns|Beast}}" AND Cards.customCycles HOLDS "BG tavern token"|orderBy={{Cards tb|techLevel}} ASC, {{Cards tb|name}} ASC}}

==See also==
*[[Form:BG/Minion]]
*[[Special:RunQuery/BG/Minion]]
</noinclude>
<onlyinclude>{{#cargo_query:tables=Cards=C, CardsRace
|join=Cards.raceId=CardsRace.id
|fields={{#switch:{{lc:{{{layout|}}}}}
|#default={{Cards tb|bg_reg_ver}}=link, Cards._pageName=link2, {{Cards tb|name}}=name, {{Cards tb|race}}=race, {{Cards tb|techLevel}}=techLevel, {{Cards tb|attack}}=attack, {{Cards tb|health}}=health, {{Cards tb|text}}=text, {{Cards tb|bg_image}}=image, {{Cards tb|battlegroundsPremiumDbfId}}=battlegroundsPremiumDbfId
|count=COUNT(DISTINCT Cards._pageName)=count
}}
|where=1=1 {{#if:{{{where|}}}|AND {{{where}}}|{{#if:{{{title|}}}|AND C.Title LIKE "%{{{title}}}%"}}{{#if:{{{subtitle|}}}|AND C.Subtitle LIKE "%{{{title}}}%"}}{{#if:{{{subtitle|}}}|AND {{Cards tb|dbfId}}="{{{dbfId}}}"}}{{#if:{{{id|}}}|AND {{Cards tb|id}}="{{{id}}}"}}{{#if:{{{text|}}}|AND ({{#lstmap:{{{text}}}|\_|@@|{{Cards tb|text}} LIKE "%@@%"|{{#switch:{{{textAdvanced}}}|#default=\_OR\_|And=\_AND\_}}}})}}{{#if:{{{techLevel|}}}|AND ({{#lstmap:{{{techLevel}}}|,|@@|{{Cards tb|techLevel}}="@@"|\_OR\_}})}}{{#if:{{{attack|}}}|AND ({{#lstmap:{{{attack}}}|,|@@|{{Cards tb|attack}}="@@"|\_OR\_}})}}{{#if:{{{attackNot|}}}|AND NOT ({{#lstmap:{{{attackNot}}}|,|@@|{{Cards tb|attack}}="@@"|\_OR\_}})}}{{#if:{{{attackLess|}}}|AND {{Cards tb|attack}}<="{{{attackLess}}}"}}{{#if:{{{attackMore|}}}|AND {{Cards tb|attack}}>="{{{attackMore}}}"}}{{#if:{{{health|}}}|AND ({{#lstmap:{{{health}}}|,|@@|{{Cards tb|health}}="@@"|\_OR\_}})}}{{#if:{{{healthNot|}}}|AND NOT ({{#lstmap:{{{healthNot}}}|,|@@|{{Cards tb|health}}="@@"|\_OR\_}})}}{{#if:{{{healthLess|}}}|AND {{Cards tb|health}}<="{{{healthLess}}}"}}{{#if:{{{healthMore|}}}|AND {{Cards tb|health}}>="{{{healthMore}}}"}}{{#switch:{{lc:{{{elite}}}}}|#default=|1|yes|true=AND {{Cards tb|elite}}="1"|1|no|false=AND NOT {{Cards tb|elite}}="1"}}{{#if:{{{races|}}}|AND ({{#lstmap:{{{races}}}|,|@@|<esc>{{#switch:@@|General=Cards.raceId IS NULL|#default=(CardsRace.renderName="@@" OR Cards.race="@@")}}</esc>|\_OR\_}})}}{{#if:{{{abilities|}}}|AND ({{#lstmap:{{{abilities}}}|,|@@|{{Cards tb|abilities}} HOLDS "@@"|\_OR\_}})}}{{#if:{{{abilitiesNot|}}}|AND NOT ({{#lstmap:{{{abilitiesNot}}}|,|@@|{{Cards tb|abilities}} HOLDS "@@"|\_OR\_}})}}{{#if:{{{tags|}}}|AND ({{#lstmap:{{{tags}}}|,|@@|{{Cards tb|tags}} HOLDS "@@"|\_OR\_}})}}{{#if:{{{tagsNot|}}}|AND NOT ({{#lstmap:{{{tagsNot}}}|,|@@|{{Cards tb|tags}} HOLDS "@@"|\_OR\_}})}}{{#if:{{{cycles|}}}|AND ({{#lstmap:{{{cycles}}}|,|@@|Cards.customCycles HOLDS "@@"|\_OR\_}})|AND {{bg buyable}}}}{{#if:{{{pools|}}}|AND ({{#lstmap:{{{pools}}}|,|@@|<esc>{{#switch:@@|General={{Bg general pool}}|#default={{Bg minion pool|@@}}}}</esc>|\_OR\_}})}}}}
|groupBy={{#switch:{{lc:{{{layout|}}}}}
|count=
|#default=Cards._pageName
}}
|orderBy={{{orderBy|{{Cards tb|techLevel}} ASC, {{Cards tb|name}} ASC}}}
|format=template
|template={{#switch:{{lc:{{{layout|}}}}}
|#default=List cards bg minions/layout
|table golden=List cards bg minions/layout golden
|image=Card layout
|image golden=Card layout bg golden
|count=Count layout
}}
|limit={{#switch:{{lc:{{{layout|}}}}}
|#default={{{limit|500}}}
|count=1
}}
|offset={{{offset|}}}
|intro={{#if:{{{originalPage|}}}|<span class="button">Return to [[{{{originalPage}}}]]</span>}}{{#switch:{{lc:{{{layout|}}}}}
|#default=<table class="wikitable mw-collapsible {{#switch:{{lc:{{{collapsed}}}}}|#default=mw-collapsed|0|no|n|false=}} sortable" width="100%"><tr><th>Name</th><th>Minion type</th><th>Tier</th><th>Atk</th><th>Health</th><th>Description</th></tr>
|image|image golden=<table width="100%" class="mw-collapsible {{#switch:{{lc:{{{collapsed}}}}}|1|yes|true=mw-collapsed|#default=}}"><caption><b>{{{title|Battlegrounds minions}}}</b><br/><i class="mobileonly">Swipe left or right to see the cards.</i></caption><tr><td class="mw-collapsible-content" style="text-align:center"><div class="list-cards">
|count=
}}
|outro={{#switch:{{lc:{{{layout|}}}}}
|#default=</table>
|image|image golden=</div></td></tr></table>
|count=
}}{{#if:{{{originalPage|}}}|<span class="button">Return to [[{{{originalPage}}}]]</span>}}
}}</onlyinclude>

Template:CardQuery - Revision history

Teltura: Created page with "This template is a Battlegrounds version of {{t|List cards}} that returns only Battlegrounds minions. ==Usage==
{{CardQuery |layout= |where= |orderBy= |co..."