Jun 01, 2020 10:52 AM|PatriceSc|LINK
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.