in reply to DBIx::Class Build a Where Clause with multiple ORs and ANDs
I was successful able to produce this Where Clause:
using this snippet of code:( sent_email is NULL OR sent_email='0000-00-00');
sent_email => {'!=', undef }, sent_email => {'!=', '0000-00-00
Are you sure, the code logic is NOT equal ? Try
pojmy @proc_requests = $schema->resultset( 'TblRequests' )->search({ -or =>[ status => 'Review' , -and => [ -or => [ status => 'Offered', status => 'Denied', status => 'Cancelled', status => 'Conditional Offer', ], -or => [ sent_email => {'=', undef }, sent_email => {'=', '0000-00-00'}, ] ], ], }, { join => 'p' } );
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: DBIx::Class Build a Where Clause with multiple ORs and ANDs
by phildeman (Scribe) on Jan 03, 2018 at 15:34 UTC | |
by poj (Abbot) on Jan 03, 2018 at 16:10 UTC | |
by 1nickt (Canon) on Jan 03, 2018 at 15:55 UTC |
In Section
Seekers of Perl Wisdom