Template:Query keystone passive skills: Difference between revisions

From Path of Exile Wiki
Jump to navigation Jump to search
>Illviljan
m (Go directly to module instead, since it's not possible to overwrite default q_where.)
No edit summary
 
(4 intermediate revisions by 3 users not shown)
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 IS NOT NULL
   (passive_skills.ascendancy_class <= "" OR passive_skills.ascendancy_class is NULL)
  AND passive_skills.ascendancy_class IS NULL  
   AND passive_skills.is_keystone = 1
   AND passive_skills.is_keystone = 1
   AND passive_skills.stat_text IS NOT NULL
   AND passive_skills.stat_text > ""
   {{#if: {{{where|}}}|AND ({{{where|}}})|}}
   {{#if: {{{where|}}}|AND ({{{where|}}})|}}
|q_orderBy={{{q_orderBy|passive_skills.name}}}
|q_orderBy={{{q_orderBy|passive_skills.name}}}

Latest revision as of 14:13, 17 July 2022

Template documentation[view] [edit] [history] [purge]


Lua logo

This template uses the following modules:

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 and non-keystone 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.