How to control the sort of a calculated field?

How to control the sort of a calculated field?

oobioobi Posts: 1Questions: 1Answers: 0

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?

This discussion has been closed.