@@ -, +, @@ --- C4/Utils/DataTables.pm | 5 +++++ 1 file changed, 5 insertions(+) --- a/C4/Utils/DataTables.pm +++ a/C4/Utils/DataTables.pm @@ -100,6 +100,11 @@ sub dt_build_orderby { $i++; } + return unless @orderbys; + + # Must be "branches.branchname asc", "borrowers.firstname desc", etc. + @orderbys = grep { /^\w+\.\w+\s(asc|desc)$/ } @orderbys; + $orderby = " ORDER BY " . join(',', @orderbys) . " " if @orderbys; return $orderby; } --