Which method really works if search results listing (doesn't matter, simple search or advanced one, both are the same) should be sorted by Last name, not by Contact ID? Things we've tried so far (none works):

  1. "Include Order By Clause" radio button at Administer -> Customize Data and Screens -> Search Preferences (per this suggection)
  2. Individual Sort Name Format at yoursite/civicrm/admin/setting/preferences/display?reset=1 per this suggestion
  3. Sort name checked in the DB, no influence on search results display.

Guess there should be some kind of "easy fix" like adding "ORDER BY LAST_NAME DESC" somewhere among templates. Or we need to go deeper into hooks/custom extension system?

  • Have you tried the settings in civicrm/admin/setting/search?reset=1 you should be able to have an alpha pager and set the sort results? Commented Nov 17, 2015 at 17:32
  • Also by default CiviCRM is set to sort by last name, check the sort name setting in this page civicrm/admin/setting/preferences/display?reset=1 Commented Nov 17, 2015 at 17:38
  • @Parvez Saleh Thank you for notes; yes, I've tried both and even mentioned this in an initial question, in order to highlight, that standard ways doesn't work..
    – yurg
    Commented Nov 17, 2015 at 17:53
  • If you have access to the Database you can check what values are stored in the sort_name field for the contacts, if this is wrong/incorrect then that might be the issue and they'll need to be re-evaluated, which can be done using CiviCRM functions. Commented Nov 18, 2015 at 9:51
  • @Parvez Saleh Thank you for note; that is what we've done before, as it stated in #3 of the initial question..
    – yurg
    Commented Nov 19, 2015 at 18:29


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.