8,756
edits
Teamtoto
Joined 25 July 2021
m
no edit summary
m (→QBE TODO) |
mNo edit summary |
||
| Line 56: | Line 56: | ||
*what does DynamicObjectsTable:Saltdunes_Creatures:Weight Value=3 do? | *what does DynamicObjectsTable:Saltdunes_Creatures:Weight Value=3 do? | ||
*also DynamicObjectsTable:Snapjaws:Builder | *also DynamicObjectsTable:Snapjaws:Builder | ||
==Notes== | |||
from [https://pathofexile.gamepedia.com/index.php?title=Path_of_Exile_Wiki:Known_issues] | |||
====HOLDS doesn't work as expected==== | |||
Cargo bug. Instead of using HOLDS try, *__full instead. The lists then becomes a ordinary string and can be queried as such. | |||
Example: | |||
* Replace <code>skill_gems.gem_tags HOLDS "Aura"</code> with <code>skill_gems.gem_tags__full LIKE "%Aura%"</code> | |||
* Use [https://dev.mysql.com/doc/refman/5.5/en/regexp.html regexp] for more advanced queries: <code>events.id__FULL REGEXP "(, {{!}}^)SSF Abyss(, {{!}}$)"</code>. | |||
** The delimiter in this case is <code>, </code> | |||
** Replace <code>|</code> with <code><nowiki>{{!}}</nowiki></code> in normal wikitext. | |||
====Case sensitivity==== | |||
Cargo is case insensitive. Use BINARY instead. Read more [https://www.mediawiki.org/wiki/Extension:Cargo/Common_problems here]. | |||