https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28633
--- Comment #80 from Nick Clemens (kidclamp) <[email protected]> --- (In reply to Katrin Fischer from comment #79) > (In reply to Martin Renvoize from comment #78) > > Something like `ORDER BY COALESCE(NULLIF(preferred_name, ''), first_name), > > last_name` you mean? > > > > We'll still need to work out how to wrap that for the API... > > Yes, because I think having it as a real database column might add some > technical debt/more stuff to maintain. If we could avoid it with reasonable > effort that might be nice. It's the combination of API and Datatables here that I was unable to resolve - the query is being bult by datatables, so I think we would need to intercept the sorting column in the API and convert it to the SQL we need. IMO the column simplifies the code we need in the end, but am happy to see if someone else can solve the API issue -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ 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/
