[Dbix-class] Incorrect SQL being generated after DBIC library
upgrade
David Ihnen
davidi at norchemlab.com
Thu Mar 19 19:53:24 GMT 2009
Anthony Gladdish wrote:
>
> Any ideas or suggestions from anyone would be great.
>
Since hashref are ands already, simplyfing it is what I'd do
my $orders_current = $schema->resultset('Order')->search(
{ -or => [ "module_access.expires" => { ">", DateTime->now() },
"scheme_access.expires" => { ">", DateTime->now() },
],
"me.person" => $self->id(),
},
{
distinct => 1,
join => ['module_access','scheme_access'],
}
);
More information about the DBIx-Class
mailing list