Hi,

Showing too much code variation makes harder to understand what you tried or want. If I understood for now you can group data on a date and the missing part is sorting on a child collection within each group?

apptDate and calOId are part of the same table? 

Edit: when something goes wrong and I can't make progress I prefer to test on sample which is as simple as possible to test really just the particular point on which I have my issue.