Template:Query base passive skills: Difference between revisions

From Path of Exile 2 Wiki
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

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 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.

Yes

Subpages

No results