Advertisement
Guest User

Perl query

a guest
Apr 9th, 2012
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Perl 0.62 KB | None | 0 0
  1. my $messages = $c->model('Database::Messages')->search({-or => [
  2.                             {-and => ['me.source' => $uid, -or => ['me.is_system' => 0, 'me.is_system' => undef]]},
  3.                             'me.target' => $uid
  4.                         ]
  5.                         },
  6.         {
  7.         select => [\['DISTINCT ON(me.thread) me.thread'], qw/me.id me.source me.target me.date me.title me.text me.car me.transaction me.payment me.is_read/],
  8.         prefetch => ['source_linked', 'target_linked', 'car_linked', 'payment_linked', 'transaction_linked'],
  9.         as => [qw/me.thread me.id me.source me.target me.date me.title me.text me.car me.transaction me.payment me.is_read/],
  10.         page => $page, rows => $rows
  11.         });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement