views:

15

answers:

0

I want to do the equivalent of (A<y AND B>x) OR (C < y AND D>x). 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?