This site makes extensive use of JavaScript.
Please enable JavaScript in your browser.

Advanced Wowhead search (SQL)?

Post by Rylia

Is there a way to access a more advanced item filtering of the wowhead database? The existing filtering is great, but it's often not powerful enough for what I want to do. For example, if I'm trying to gear up my warlock alt for raiding with just crafted and rep gear, I might add the following filters (in addition to usable-by: warlock + level 71-80):

resilience=0 (exclude pvp gear)
AND agility=0 AND attack power =0 (caster gear only)
... but then I want to look at EITHER crafted OR rep gear, so
I want to add
AND (bind on equip OR requires rep with any).

But you can't nest an OR within an AND. You also can't arbitrarily negate things (it would be handy to just do NOT (source=drop)).

I'm wondering if the "create a filter" just translates into an SQL query to the database, and whether there's a way to more directly access that underlying SQL or similar more powerful query language.

thanks!

Post by Gryphon

What you see is what you get. Boolean filter's are on the list of things to add, but not currently a priority.

Post by 312693

This post was from a user who has deleted their account.

Post by MeanMachine

You know, I can think of a thousand reasons why SQL would not be such a good idea. Then again, just one is enough ...

Custom Filter:
UNION DELETE * FROM accounts

Yeah ...

Advanced Wowhead search (SQL)?

Post Reply