Jump to content


Sort Order, Groups and Custom Reports

Sort order groups custom reports

  • Please log in to reply
2 replies to this topic

#1 Bob C

Bob C

    Advanced Member

  • Members
  • PipPipPip
  • 269 posts

Posted 14 June 2018 - 02:20 PM

I just came across a difference in sort order between a Group in the sidebar and a sorted custom report. In the Group sidebar they were sorted by last name, given with individuals with no middle given name appearing before those with a middle given name.


In a custom report based upon the group and sorted by surname and then given name, the individuals with middle given names  sorted before those without.


Either there are two sort functions being used or a collation sequence is different between the two sorts.




#2 TomH


    Advanced Member

  • Members
  • PipPipPip
  • 6448 posts

Posted 14 June 2018 - 04:09 PM

Two different sort systems and, possibly, two different collation sequences. I suspect the group in the sidebar is a SQLite sort using the RMNOCASE collation while the custom report might be a Delphi sort with an unknown collation.

Tom user of RM7630 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.

#3 Renee Zamora

Renee Zamora

    Advanced Member

  • Admin
  • PipPipPip
  • 8788 posts

Posted 15 June 2018 - 09:21 AM

Confirming this difference is noted in the development list. 


Also tagged with one or more of these keywords: Sort order, groups, custom reports