Solved Copied list does not group in alpha order

[tghounsell]

Today I made a copy of a list (so that I could have some joins in one list view while keeping my forms distinct). After copying the list, i noticed that no matter what i did, I could not get the copied list to display groups in any order. I tried a few different fields as the field to group on, and all of them produce unordered results. (I suspect the order is actually according to which group value is found next in the list.) Changing the order direction doesn't help. The problem occurs in both the front and back end. There is no problem with the original list. Here's a screen shot of the list in the front end:

And here are the group settings:

I am running j5.1 with the manual update installed. Joomla Debug is on and there are no messages on this page.

 

[wezetel]

Did you try to set the sorting in the data tab (in your screenshot left from 'group by' )

 

[tghounsell]

Did you try to set the sorting in the data tab (in your screenshot left from 'group by' )

Yes, the records were sorted by a name field. Changing the sort order doesn't seem to change/correct the group ordering issue. Columns that don't appear alphabetize correctly in the group by do alphabetize correctly in as a record sort order. So the problem doesn't seem related to my data. Was that the thinking behind the question?

Even after adding the group-by field to the data sort, the groups sort weirdly. Here it is with records sorted by last name (of the primary member) and by membership type and grouped by membership type:

 

[troester]

As @wezetel said: To order your "group by" element (city in your 1st example) you must set the "Order by" in the Data tab.

Order by in "Group by" tab is for the order inside each group.

 

[tghounsell]

Wow! So the record sort order needs to include the group by order element! Amazing and extremely unexpected!