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

(-)a/C4/Koha.pm (-2 / +5 lines)
Lines 1076-1082 sub GetAuthorisedValues { Link Here
1076
    if(@where_strings > 0) {
1076
    if(@where_strings > 0) {
1077
        $query .= " WHERE " . join(" AND ", @where_strings);
1077
        $query .= " WHERE " . join(" AND ", @where_strings);
1078
    }
1078
    }
1079
    $query .= " GROUP BY lib ORDER BY category, " . ($opac ? "lib_opac, lib" : "lib, lib_opac");
1079
    $query .= " GROUP BY lib";
1080
    $query .= ' ORDER BY category, ' . (
1081
                $opac ? 'COALESCE(lib_opac, lib)'
1082
                      : 'lib, lib_opac'
1083
              );
1080
1084
1081
    my $sth = $dbh->prepare($query);
1085
    my $sth = $dbh->prepare($query);
1082
1086
1083
- 

Return to bug 10656