search

binarylogic / searchlogic

Searchlogic provides object based searching, common named scopes, and other useful tools.
http://rdoc.info/projects/binarylogic/searchlogic
MIT License
1.4k stars 133 forks source link

How can I use OR with a GROUP of ANDS? #129

Open timfong888 opened 13 years ago

timfong888 commented 13 years ago

I want to do the equivalent of (Ay) OR (Cy). how can i do that?

Right now, I am creating separate queries:

@companies_with_email = Company.contact_emails_date_sent_gt(@monday).
                               contact_emails_date_sent_lt(@friday).
                               find(:all, :select => "distinct companies.*")  || [] 

@companies_with_calls = Company.contact_calls_date_sent_gt(@monday).
                               contact_calls_date_sent_lt(@friday).
                               find(:all, :select => "distinct companies.*")  || []

And then I @companies_with_calls + @companeis_with_emails

But this will continue to create problems since I don't want duplicates.

I'd like to be able to do it within searchlogic, is this possible?

graywh commented 12 years ago

I'm using searchlogic in an old rails 2.3 app (using ransack with all 3.x apps; really need to upgrade this one) and just ran into a case that could use this functionality.