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

(-)a/Koha/Virtualshelves.pm (-4 / +3 lines)
Lines 55-61 sub get_private_shelves { Link Here
55
        },
55
        },
56
        {
56
        {
57
            join => [ 'virtualshelfshares' ],
57
            join => [ 'virtualshelfshares' ],
58
            group_by => 'shelfnumber',
58
            distinct => 'shelfnumber',
59
            order_by => 'shelfname',
59
            order_by => 'shelfname',
60
            ( ( $page and $rows ) ? ( page => $page, rows => $rows ) : () ),
60
            ( ( $page and $rows ) ? ( page => $page, rows => $rows ) : () ),
61
        }
61
        }
Lines 73-79 sub get_public_shelves { Link Here
73
            category => 2,
73
            category => 2,
74
        },
74
        },
75
        {
75
        {
76
            group_by => 'shelfnumber',
76
            distinct => 'shelfnumber',
77
            order_by => 'shelfname',
77
            order_by => 'shelfname',
78
            ( ( $page and $rows ) ? ( page => $page, rows => $rows ) : () ),
78
            ( ( $page and $rows ) ? ( page => $page, rows => $rows ) : () ),
79
        }
79
        }
Lines 116-122 sub get_some_shelves { Link Here
116
        },
116
        },
117
        {
117
        {
118
            join => [ 'virtualshelfshares' ],
118
            join => [ 'virtualshelfshares' ],
119
            group_by => 'shelfnumber',
119
            distinct => 'shelfnumber',
120
            order_by => { -desc => 'lastmodified' },
120
            order_by => { -desc => 'lastmodified' },
121
        }
121
        }
122
    );
122
    );
123
- 

Return to bug 21612