xivdb.com

[Hulan]

One suggestion that I saw.. On the gear filter, when filtering by stats can you change it to be a and/or situation? Basically I was searching to find crafting gear. I put Control, Craftmanship and Magic Craft as filter options, it only brought up 1 item that had all 3. Would be cool to be able to filter on an OR statement instead of just an AND statement.

AND OR queries are hard to represent easily through a GUI due to order of operation ambiguity. Is the query [int > 10 AND mnd > 5 OR macc > 12] actually [(int > 10 AND mnd > 5) OR macc > 12] or is it [int > 10 AND (mnd > 5 OR macc > 12)]?

That being said, this would indeed be very useful. Either give us order of operation operators or force a simple front to back precedence and I would be behind this suggestion 100%.

[neminis]

Very good suggestion i will look into it what it would take to do or filters (=

[Romowens01]

AND OR queries are hard to represent easily through a GUI due to order of operation ambiguity. Is the query [int > 10 AND mnd > 5 OR macc > 12] actually [(int > 10 AND mnd > 5) OR macc > 12] or is it [int > 10 AND (mnd > 5 OR macc > 12)]?

That being said, this would indeed be very useful. Either give us order of operation operators or force a simple front to back precedence and I would be behind this suggestion 100%.

Haha tricky.
I code some too so I know exactly what you are talking about.
Since you don't want to make it too complex for the end users, it would probably be best to leave it as all AND or all OR. Just have a radio button selection between AND and OR. Then insert the option into the look up code.
I'm better at SQL/VB than Java, but the end result would be something like...

useroption = optionbox.selectedvalue
int > 10 [useroption] mnd > 5 [useroption] macc > 12

[viion]

Haha tricky.
I code some too so I know exactly what you are talking about.
Since you don't want to make it too complex for the end users, it would probably be best to leave it as all AND or all OR. Just have a radio button selection between AND and OR. Then insert the option into the look up code.
I'm better at SQL/VB than Java, but the end result would be something like...

useroption = optionbox.selectedvalue
int > 10 [useroption] mnd > 5 [useroption] macc > 12

This is pretty much how it will be, i think lol idk what Nemi is doing =O but I suggested adding in checkbox