Template:Query base passive skills: Difference between revisions
Jump to navigation
Jump to search
(Fixing query to work with our cargo. The comparisons against NULL weren't working.) |
(If we use comparisons like this, it should work regardless of whether we're using strings or NULLs) |
||
| Line 3: | Line 3: | ||
|q_join=passive_skills._pageID=passive_skill_stats._pageID | |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 = "" | AND 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 > "" | ||
{{#if: {{{where|}}}|AND ({{{where|}}})|}} | {{#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}}} | ||
Revision as of 03:02, 17 October 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.