$schema->resultset( 'TblRequests' )->search([ { status => 'Review' }, { status => [ 'Offered', 'Denied', 'Cancelled', 'Conditional Offer' ], sent_email => { '!=' => [ -and => undef, '0000-00-00' ] }, }, ]);