[Dbix-class] applying sql not function in where clause

Peter Rabbitson rabbit+dbic at rabbit.us
Fri Sep 4 15:24:33 GMT 2009


mohanprasad wrote:
> Hi,
> 
> I am trying to prepare the below where clause
> where not(status ='deleted' and created < $timestamp)
> 

SQL::Abstract 1.58 just went to cpan (still in incoming).
It allows you to do:

({ -not_bool => {
    status => 'deleted',
    created => { '<', $timestamp },
}})






More information about the DBIx-Class mailing list