Template:Custom spell card table

This template shows a table listing spell cards according to the criteria specified to the parameters below.

Note: All parameters below are optional. If left blank, they will not affect what cards are shown.

{{Spell card table
  |categoryname=the exact name of a category to get cards from, not including the Category prefix. Multiple names can be provided separated by commas, and cards are returned only if they are in all the given categories.
  |category=name prefix of category to get cards from, should match that used for the category parameter on Card infobox. Multiple names can be provided separated by commas, and cards are returned only if they are in all the given categories.
  |name=name of card(s) to show
  |subtype=school of cards to show
  |class=class of cards to show, using "Any" for neutral cards
  |multiclass=multiclass of cards to show
  |rarity=rarity of cards to show
  |mana=mana cost of cards to show (a range can be specified using a minimum and maximum separated by ~)
  |gold=True to show only cards with a gold version, False to show only cards that do not
  |ability=show cards with this ability (currently, only one ability can be used as a selector)
  |artist=show cards with this artist
  |voiceactor=show cards with this voice actor
  |tag=show cards with this tag (currently, only one tag can be used as a selector)
  |hiddentag=show cards with this hiddentag (currently, only one tag can be used as a selector)
  |collectible=True to show only collectible cards, False to show only uncollectible cards
  |set=page name of a set of cards to show (currently, only one set can be used as a selector)
  |where=Overrides all other selection parameters above with an explicitly written Cargo query "where" clause.
}}

Unlike {{Custom card table}}, which can list cards of any type, this template is hard-coded to only list spell cards. However, this table omits four columns that are unnecessary when listing only spell cards:

• The type column, since this is only going to list spell cards anyway.
• The attack column.
• The hp column.

Therefore, it is cleaner for lists that won't include other card types. See also {{Custom weapon card table}} and {{Custom minion card table}} for those card types.

, can be used as a separator for multiple options in most of the fields for this template:

• |class=Any,Priest specifies priest cards or neutral cards
• |rarity=Legendary,Epic specifies either of the highest two rarities

While the parameters above offer a lot of flexibility, they don't offer the full possible range of options the where parameter of #cargo_query permits. In this case, the where parameter can be used instead. See Extension:Cargo/Querying_data for details on the where parameter, and both the Cards and _pageData tables. As the query joins these tables, fields from both are available for use in where. Note that (Cards.type="Spell") AND is automatically prepended. (Those familiar with SQL will find this familiar, since it is nearly identical to the WHERE clause in a SELECT statement.)

See also

• {{List cards}}
• {{Cards}}, which produces card images instead of a table
• {{Custom card count}}, which counts cards instead of listing them