filtering using OR criterea

[Tim Uckun]

Is there a way to have OR in your filter criterea? It seems like every filter you add is ANDed.

Thanks.

[Benoit Bénézech]

No, you can't.

[Tim Uckun]

On Thu, Mar 15, 2012 at 10:18 PM, Benoit Bénézech
<benoit....@gmail.com> wrote:
> No, you can't.

Bummer. Is this feature planned at any point?

[Benoit Bénézech]

No; I think it would be hard to implement in the general case. (the UI would be really tricky, especially).

Now if you want to  'AND' or 'OR' ALL your filters, then you can pass the 'OR' as a param and hack smtg in the two adapters, quite easy. (both AR and Mongoid support it).

[Tim Uckun]

On Fri, Mar 16, 2012 at 11:29 PM, Benoit Bénézech
<benoit....@gmail.com> wrote:
> No; I think it would be hard to implement in the general case. (the UI would
> be really tricky, especially).

I have some old code that does this...

There is a drop down box with all the fields in it. When you click on
it it fills the "operatators" dropdown according to the type of the
field (greater than, contains etc). There is a box for the param.
After the param there is a dropdown box with "and, or" as options. If
you want another param you click and or or and it creates a new row
for the next filter. In your gui it would be easy enough to always
have a dropdown after the params with an AND or OR options.

For something even more sophisticated you can look at the jqgrid
advanced search functionality.

> Now if you want to  'AND' or 'OR' ALL your filters, then you can pass the
> 'OR' as a param and hack smtg in the two adapters, quite easy. (both AR and
> Mongoid support it).
>

Ideally I could pick and choose like date > X AND date < Y or date is
null but I can see where grouping might be handy too.

>>
>> Bummer. Is this feature planned at any point?
>

> --
> You received this message because you are subscribed to the Google Groups
> "rails_admin" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/rails_admin/-/H6uzPwt8S-AJ.
>
> To post to this group, send email to rails...@googlegroups.com.
> To unsubscribe from this group, send email to
> rails_admin...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/rails_admin?hl=en.

[Benoit Bénézech]

Sure, it's doable. If you have the time, you're very welcome ;-)

If you make it recursive (AND/OR mixed in same request), you'll have to update all three adapters (someone is working on DataMapper and might integrate it).

[Tim Uckun]

On Mon, Mar 19, 2012 at 4:19 AM, Benoit Bénézech
<benoit....@gmail.com> wrote:
> Sure, it's doable. If you have the time, you're very welcome ;-)
> If you make it recursive (AND/OR mixed in same request), you'll have to
> update all three adapters (someone is working on DataMapper and might
> integrate it).

If I have time I'll poke at it for a while and see what comes out.

[Sherban Drulea]

Hi. I need OR filters also. Has there been any update on this?