Template:TableofEventsPerYear

Template documentation
Note: portions of the template sample may not be visible without values provided.
View or edit this template's documentation. (About template documentation)

Example(s)

• {{TableofEventsPerYear|22|count=5}} gives:

There were 332 events in 2022. Tap column header arrows to sort.

(refresh data)

Event Name	Event Date	Event Type	Prize Dragon(s)	Event Type Notes
Farming Fanatic (edit)	30 December 2022	Food Gathering	Memorial Dragon
Golden Opportunity (edit)	30 December 2022	Gold Spending	Posh Dragon
Bottomless Dungeon (edit)	26 December 2022	Bottomless Dungeon	Holly Dragon  Laohu Dragon
Tyrant Chest (edit)	26 December 2022	Chest Opening	Earth Spirit Dragon  Laser Hammer Dragon  Tundra Dragon
Dragon Grid (edit)	26 December 2022	Dragon Grid	Armored Phasm Dragon  Aureum Lumen Dragon  Daemonia Dragon  Prisma Dragon

More...

• {{TableofEventsPerYear|23}} creates a table of events for 2023.
• {{TableofEventsPerYear|23|count=3|collapsible=y|collapsed=y}} creates a table of events for 2023 that are both collapsible and collapsed.

Important Notes

For the Prize Dragon(s) column, to use with {{PAGENAME}} its parent column should be stored using #titleparts of ParserFunctions, which removes needless HTML encoding:

• |eventdragonslist = {{#titleparts:{{EventsTableDragonList|{{PAGENAME}}}}}}.

If a column is stored as List (,) of Wikitext string, querying the __full result (the entire comma-separated string, and not each virtual list field individually) is likely easiest, or easiest when multiple criteria are needed. This allows LIKE or IN to be used instead of HOLDS.

• columnName LIKE "%name,% (including the comma at the end to avoid getting similar results)
• columnName IN ("value,", "value2,", "value3,")

Also, for some reason, if a field generates an HTML space, it must be stripped for empty results:

• IF(eventdragonslist__full != " ", eventdragonslist__full, "")=eventdragonslist

• If querying single params, when stored as List (,) of Wikitext string, use HOLDS to search the individual results.

See Also

• {{TableofEventsPerYear-CargoRow}}, the formatting template called in this one, that formats a row of output and is reapplied to every row.
• {{Cargo}}, the template used to eliminate undesired before/after space inserted by Cargo intro/outro.
• {{TableofEvents3Months-DPL3}}, the DPL3 version limited to fewer results as it's slow.
• {{IslandEventsTable}}, a similar template but for events linking to a certain page.
• {{EventsTableDragonList}}, the template that stores one of the results used in this query.

Creates a Cargo table of all events pages (Category:Events) for the year specified, and populates the prize dragons column based on dragons linked to from each Event page. Results are limited to the count set, or the default max of 500.

Template parameters

Parameter		Description	Type	Status
year (YY)	1	Last 2 digits of the year the event appeared. Default 23 Example 19	Number	optional
(Override) count	count limit	no description Default 500 Example 200	Number	optional
(Override) offset	offset	Setting a number offsets results by that, useful if results need to be paginated, displays the next x number of results. Default 0 Example 250	String	optional
collapsible	collapsible	If any value is set, makes the table collapsible Example y	String	optional
collapsed	collapsed	If any value is set, makes a collapsible table collapsed by default. Example y	String	optional