Template:Query base passive skills: Difference between revisions
Jump to navigation
Jump to search
(If we use comparisons like this, it should work regardless of whether we're using strings or NULLs) |
(Allow null or empty string values for ascendancy_class.) |
||
| Line 4: | Line 4: | ||
|q_where= | |q_where= | ||
passive_skills.connections__full > "" | passive_skills.connections__full > "" | ||
AND passive_skills.ascendancy_class | 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 passive_skills.stat_text > "" | AND passive_skills.stat_text > "" | ||
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
No results
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.