or but not and ? #41

Closed
pasqal opened this Issue Jul 4, 2011 · 1 comment

Projects

None yet

2 participants

@pasqal
pasqal commented Jul 4, 2011

Hi,
I try to explain my idea
i have 2 value in database : "min." and "max."
I need to search all items where the value (type by users in search form) is in this 2 points.

I try in form :
text_field :min.gte
text_field :max.lte

i need min.gte AND max.lte, but the metasearch make min.gte OR max.lte

I try
text_field :eq_hab_mini_eq_hab_max_all ,doesn't work!

i don't know how to use multiparameter-between in this case, with to different DB column name.

Is it possible to make a option AND with 2 text_field or in the multiparameter_field.

Thx

@ernie
Member
ernie commented Jul 5, 2011

One suggestion: yry Ransack, which allows for both and/or. This isn't somethign I'm going to be adding to metasearch at this point.

You might also consider creating a custom where, which takes two parameters and does the query you mentioned.

@ernie ernie closed this Jul 5, 2011
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment