[jifty-devel] Using OR in a Collection->limit
Henry.Baragar at instantiated.ca
Thu Oct 12 10:44:35 EDT 2006
We need to be able to select rows
select * from Trade where tdate = '2006-10-11' and (buyer = 21 or seller = 21)
Here is our attempt using a Jifty collection:
$date = '2006-10-11';
$cust = 21;
my $trades= Billing::Model::TradeCollection->new;
$filled->limit(column => "tdate", value => $date);
$filled->limit(column => "buyer", value => $cust);
$filled->limit( entry_aggregator => 'or',
column => "seller", value => $cust);
The "OR" never gets into the select clause: The last two limit's are "AND"ed.
What are we doing wrong? How do we fix this?
More information about the jifty-devel