my @proc_requests = $schema->resultset( 'TblRequests' )->search({
-or => [
status => 'Offered',
status => 'Denied',
status => 'Cancelled',
status => 'Conditional Offer',
],
-and => [
-or => [
sent_email => {'!=', undef },
sent_email => {'!=', '0000-00-00'},
],
],
},
{ prefetch => 'p' }
);
####
my @proc_requests = $schema->resultset('TblRequests')->search(
{
-or => [
status => 'Offered',
status => 'Denied',
status => 'Cancelled',
status => 'Conditional Offer',
],
-and => [
-or => [
sent_email => { '!=', undef },
sent_email => { '!=', '0000-00-00' },
],
],
},
{ prefetch => 'p' }
);
####
my @proc_requests = $schema->resultset('TblRequests')->search(
{
-or => [
-or => [
status => 'Offered',
status => 'Denied',
status => 'Cancelled',
status => 'Conditional Offer',
],
-and => [
sent_email => { '!=', undef },
sent_email => { '!=', '0000-00-00' },
],
],
},
{ prefetch => 'p' }
);