https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27680
Bug ID: 27680
Summary: API DataTables Wrapper fails for ordering on
multi-data-field columns
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Architecture, internals, and plumbing
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
We can make a single column contain data from multiple 'data' points in the
ajax response using a mixture of a render function and concatenating the data
points with ':' in the data field. This allows for a nice display and
searching to work.. but the ordering call fails :(
The final patch on bug 26273 highlights this:
{
"data": "manager.firstname:manager.surname",
"searchable": true,
"orderable": true,
"render": function(data, type, row, meta) {
var fullname = row.manager.firstname + " " + row.manager.surname;
return fullname;
}
},
Assuming manager.firstname = 'Bob' and manager.surname = 'Geldoff'.. we will
display "Bob Geldoff". Searching for 'Bob' will add a suitable search header
searching for 'Bob' in both 'manager.firstname' and 'manager.surname' fields..
but hitting order by on this column will result in a 500 error as we add
'_order_by: +manager.firstname:manager.surname' to the query parameters.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
