Template:Passive skill table/doc
This subpage provides documentation for Template:Passive skill table.
Overview
This template creates an advanced tabular list for passive skills based on performing an cargo query.
Parameters
Parameter | Value | Description | Required |
---|---|---|---|
q_where | str | The where portion of the query to find tables.
passive_skills and passive_skill_stats are automatically joined and can be used freely in the query. |
✓
|
ascendancy | bool | If true, add a column for the ascendancy class of the respective passive | ✗
|
Examples
Every non-ascendancy node that grants intelligence
{{Passive skill table |q_where=passive_skill_stats.id LIKE "%intelligence%" AND passive_skills.ascendancy_class IS NULL AND passive_skills.stat_text IS NOT NULL }}
Lua error: Error 1054: Unknown column 'passive_skill_stats.id' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__passive_skills`.`is_keystone` AS `passive_skills.is_keystone`,`cargo__passive_skills`.`_pageID` AS `passive_skills._pageID`,`cargo__passive_skills`.`ascendancy_class` AS `passive_skills.ascendancy_class`,`cargo__passive_skills`.`name` AS `passive_skills.name`,`cargo__passive_skills`.`icon` AS `passive_skills.icon`,`cargo__passive_skills`.`is_notable` AS `passive_skills.is_notable`,`cargo__passive_skills`.`_pageName` AS `passive_skills._pageName`,`cargo__passive_skills`.`main_page` AS `passive_skills.main_page`,`cargo__main_pages`.`_pageName` AS `main_pages._pageName` FROM `cargo__passive_skills` LEFT OUTER JOIN `cargo__main_pages` ON ((`cargo__passive_skills`.`id`=`cargo__main_pages`.`id`)) WHERE passive_skill_stats.id LIKE "%intelligence%" AND `cargo__passive_skills`.`ascendancy_class` IS NULL AND `cargo__passive_skills`.`stat_text` IS NOT NULL GROUP BY `cargo__passive_skills`.`_pageID` ORDER BY `cargo__passive_skills`.`ascendancy_class` IS NULL DESC,`cargo__passive_skills`.`is_keystone`,`cargo__passive_skills`.`is_notable`,`cargo__passive_skills`.`name` LIMIT 5000 .
All Deadeye ascendancy nodes
{{Passive skill table |ascendancy=1 |q_where=passive_skills.ascendancy_class="Deadeye" AND passive_skills.stat_text IS NOT NULL }}