Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: DBIx::Class Build a Where Clause with multiple ORs and ANDs

by 1nickt (Abbot)
on Jan 03, 2018 at 13:40 UTC ( #1206600=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    use strict; use warnings;
    use SQL::Abstract;
    ...
    say for @bind;
    
    __END__
    
  2. or download this
    perl 1206574.pl
    
    ...
    Denied
    Cancelled
    Conditional Offer
    
  3. or download this
    $schema->resultset( 'TblRequests' )->search([
        { status => 'Review' },
    ...
          sent_email => { '!=' => [ -and => undef, '0000-00-00' ] },
        },
    ]);
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1206600]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (5)
As of 2019-02-21 07:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I use postfix dereferencing ...









    Results (109 votes). Check out past polls.

    Notices?
    • (Sep 10, 2018 at 22:53 UTC) Welcome new users!