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: koha-bugs@lists.koha-community.org Reporter: martin.renvoize@ptfs-europe.com QA Contact: testopia@bugs.koha-community.org 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.