Answers.Body: <p>There's a setting in the Administer -> Customize Data and Screens -> Search Preferences called "Include Order By Clause". If you set that to "No" (presumably to improve performance as it recommends), then your search results will be ordered by contact id even when you try to change the sort order by clicking on the column headers.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-23T21:13:44.290Z
Answers.LastActivityDate: 2015-06-23T21:13:44.290Z
Answers.UserDisplayName: Alan Dixon
Body: <p>A copy of this issue: <a href="http://forum.civicrm.org/index.php/topic,36263.msg154206.html#msg154206" rel="nofollow">http://forum.civicrm.org/index.php/topic,36263.msg154206.html#msg154206</a></p>
  
  <p>Which says: "column header sort option does nothing at my advanced search results."</p>
  
Tags: <search><search-results>
Title: Why aren't my advanced search results sorting properly?
ThreadText: # Why aren't my advanced search results sorting properly?
  
  (Asked by: username_0 on 2015-06-23)
  
  A copy of this issue: <http://forum.civicrm.org/index.php/topic,36263.msg154206.html#msg154206>
  
  Which says: "column header sort option does nothing at my advanced search results."
  
  **Tags:** search, search-results
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2015-06-23. Score: 2 | Accepted answer
  
  There's a setting in the Administer -> Customize Data and Screens -> Search Preferences called "Include Order By Clause". If you set that to "No" (presumably to improve performance as it recommends), then your search results will be ordered by contact id even when you try to change the sort order by clicking on the column headers.
  
  
  ---
  
  