View | Details | Raw Unified | Return to bug 33568
Collapse All | Expand All

(-)a/Koha/Items.pm (-1 / +4 lines)
Lines 466-475 sub search_ordered { Link Here
466
        return $self->search(
466
        return $self->search(
467
            {},
467
            {},
468
            {
468
            {
469
                '+select' => [{
470
                    lpad => ['copynumber', \8, \"'0'"], '-as' => 'lpad_copynumber',
471
                }],
469
                order_by => [
472
                order_by => [
470
                    'homebranch.branchname',
473
                    'homebranch.branchname',
471
                    'me.enumchron',
474
                    'me.enumchron',
472
                    \"LPAD( me.copynumber, 8, '0' )",
475
                    'lpad_copynumber',
473
                    {-desc => 'me.dateaccessioned'}
476
                    {-desc => 'me.dateaccessioned'}
474
                ],
477
                ],
475
                join => ['homebranch']
478
                join => ['homebranch']
(-)a/Koha/REST/V1/Biblios.pm (-1 / +1 lines)
Lines 307-312 sub get_items { Link Here
307
        $items_rs = $items_rs->filter_by_bookable if $bookable_only;
307
        $items_rs = $items_rs->filter_by_bookable if $bookable_only;
308
        # FIXME We need to order_by serial.publisheddate if we have _order_by=+me.serial_issue_number
308
        # FIXME We need to order_by serial.publisheddate if we have _order_by=+me.serial_issue_number
309
        my $items = $c->objects->search($items_rs);
309
        my $items = $c->objects->search($items_rs);
310
        delete $_->{lpad_copynumber} for @$items;
310
311
311
        return $c->render(
312
        return $c->render(
312
            status  => 200,
313
            status  => 200,
313
- 

Return to bug 33568