Template:Query base passive skills: Difference between revisions
Jump to navigation
Jump to search
>OmegaK2 (Added default order) |
(Allow null or empty string values for ascendancy_class.) |
||
| (8 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
<includeonly>{{#invoke: Passive skill|passive_skill_table | <includeonly>{{#invoke: Passive skill table|passive_skill_table | ||
|q_tables=passive_skill_stats | |||
|q_join=passive_skills._pageID=passive_skill_stats._pageID | |||
|q_where= | |q_where= | ||
passive_skills.connections__full | passive_skills.connections__full > "" | ||
AND passive_skills.ascendancy_class IS NULL | AND (passive_skills.ascendancy_class IS NULL OR passive_skills.ascendancy_class = "") | ||
AND passive_skills.is_keystone = 0 | AND passive_skills.is_keystone = 0 | ||
AND ({{{where|}}}) | AND passive_skills.stat_text > "" | ||
{{#if: {{{where|}}}|AND ({{{where|}}})|}} | |||
|q_orderBy={{{q_orderBy|passive_skills.is_notable, passive_skills.name}}} | |q_orderBy={{{q_orderBy|passive_skills.is_notable, passive_skills.name}}} | ||
|stat_text=1 | |||
|large=1 | |||
}}</includeonly><noinclude> | }}</includeonly><noinclude> | ||
{{documentation}} | {{documentation}} | ||
</noinclude> | </noinclude> | ||
Latest revision as of 03:13, 12 November 2021
Overview
This template creates an advanced tabular list for passive skills by performing a cargo query based on {{Passive skill table}}.
This variation will filter out disabled passives, as well as keystones and ascendancy passives.
Parameters
| Parameter | Value | Description | Required |
|---|---|---|---|
| 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. |
✓
|
Subpages
The above documentation is transcluded from Template:Query base passive skills/doc.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.
Editors can experiment in this template's sandbox and testcases pages.
Please add categories to the /doc subpage. Subpages of this template.