How to control the sort of a calculated field?
How to control the sort of a calculated field?
I'm trying to create an address book (basically) similar to the IOS contact app. I need the contact name data separated into FIRST and LAST names, but I want them displayed "naturally" and sorted by surname.
I have gotten as far as using a render method to append the name fields together but I'm stuck on how to sort it the way I want:
http://live.datatables.net/jacekuko/1/edit
For example: I have these values in the "name" column:
- John Smith
- Kerry Appleseed
- Terry Gilliam
I want them to sort by surname like so:
- Kerry Appleseed
- Terry Gilliam
- John Smith
Any pointers on how that might be accomplished?