[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