[Suggestion] "NOT" filter

Post Reply

Return to board index

Post by 104976

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

Post by 84594

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

Post by Malgayne

Hehe--you guys don't need to petition. We're working on it, it's not as easy as it looks. ;)

Post by 84594

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

Post by Wildhorn

Hehe--you guys don't need to petition. We're working on it, it's not as easy as it looks. ;)

!= <--- easy :P

Post by 91244

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

Post by jwiegley

A year and half later... and still no not. Just put a check box next to each filter... if checked then it inverts the filter. It will not allow an unlimited boolean expression but it sure would take care of most requests.

Post by Wildhorn

I dont see how it is not easy.

Add a textbox after every filter (and one at beginning) to allow people to type the following options:

"AND"
"OR"
"("
")"

This will allow people to make their own database command or leave it blank as it is right now if they are not familiar with it (maybe add a checkbox to toggle between advanced filter/normal filter).

For the boolean NOT, add a checkbox in front of the filters. Check in = false, unchecked = true.

So we could do something like this:

then you convert it to whatever database language you use.

This would give with SQL:

SELECT x FROM y WHERE ((BindsPickUp = 1 AND HasSockets = 0) OR Stamina>=20) AND SpellPower = 0 AND DropHeroicDungeon != Gundrak

I dont know your tables/data names so my sql command is not quite complete, but you get the idea.

Post by pelf

I'm sure their system is that simple :).

Post by Wildhorn

I'm sure their system is that simple :).

of course :P

Post by tbeseda

<3 pseudo code :)

Post by AnrDaemon

Checkbox before item...
"" Field <condition> value