Hello,
I created a CC to just display data from my database. When I add a field in the group section it does display all my data by their appropriate group. However, within the grouping I want to order by name and then by date. When I add just the field for name it breaks the data out of their groups and sorts the list by name.
How can I keep my group and then order within the group (by name and then by date)?
Thanks for your assistance,
Chris
I created a CC to just display data from my database. When I add a field in the group section it does display all my data by their appropriate group. However, within the grouping I want to order by name and then by date. When I add just the field for name it breaks the data out of their groups and sorts the list by name.
How can I keep my group and then order within the group (by name and then by date)?
Thanks for your assistance,
Chris
Hi Chris,
My understanding is that MySQL Group aggregates the results in the group and just returns one record for the group. So I'm not sure how you are seeing names as well? If you want to show data sorted by name within group then I think that you need to have both columns in the ORDER box?
Bob
My understanding is that MySQL Group aggregates the results in the group and just returns one record for the group. So I'm not sure how you are seeing names as well? If you want to show data sorted by name within group then I think that you need to have both columns in the ORDER box?
Bob
This topic is locked and no more replies can be posted.
