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?