return $self->search(
{},
{
'+select' => [{
lpad => ['copynumber', \8, \"'0'"], '-as' => 'lpad_copynumber',
}],
order_by => [
'homebranch.branchname',
'me.enumchron',
\"LPAD( me.copynumber, 8, '0' )",
'lpad_copynumber',
{-desc => 'me.dateaccessioned'}
],
join => ['homebranch']
$items_rs = $items_rs->filter_by_bookable if $bookable_only;
# FIXME We need to order_by serial.publisheddate if we have _order_by=+me.serial_issue_number
my $items = $c->objects->search($items_rs);
delete $_->{lpad_copynumber} for @$items;
return $c->render(
status => 200,
-