Template talk:Passive skill table

The Template should be corrected. In some passive skills there are IDs with zero values and the template uses them in queries. For example:

{{Query base passive skills
|where=
  passive_skill_stats.id = "attack_ailment_damage_+%_while_wielding_melee_weapon"
}}

No results found for the given query. Melee Damage and Life - in this passive skill is id attack_ailment_damage_+%_while_wielding_melee_weapon, but the value is 0. Maybe should make sure that the requests do not get id with values equal to 0?--Ruba159753 (talk) 22:28, 20 June 2019 (UTC)

Add another condition that the value has to be larger than 0:

{{Query base passive skills
|where=
     passive_skill_stats.id = "attack_ailment_damage_+%_while_wielding_melee_weapon"
 AND passive_skill_stats.value > 0
}}

No results found for the given query.

I don't think it's possible to also add passive_skill_stats.value > 0 to {{Query base passive skills}} because the user has decided to use the condition passive_skill_stats.id. The sql query wont understand which row to use when not using passive_skill_stats.id and just break everything. You could use passive_skills.stat_text to just search the shown stat text, but that will yield more work when translating it. --Illviljan (talk) 10:13, 21 June 2019 (UTC)