Sorting by scene, shot in metadata view sorts incorrectly

Hi folks,

Maybe it's just me but when I select metadata view in the media pool and then sort by scene,shot it doesn't seem to order the scene and shot as one would expect.

I'm seeing things like:

Scene 1, Shot 2
Scene 1, Shot 5
Scene 1, Shot 4
Scene 1, Shot 3

I would expect the scenes to be grouped together and ordered by shot and then if there was a take as well, the takes would be ordered within the appropriate shot:

Scene 1, Shot 1
Scene 1, Shot 1, Take 2
Scene 1, Shot 2
Scene 1, Shot 3
...

Anyone else notice this? (Resolve 17.4.2 at the moment)

I should note that it almost seems to be preferring clip name (based on filename) for the sort order within a scene but I could be mistaken.

No one else? This is killing me. I have dozens of clips tagged with scene, shot and take and my goal is to sort them by scene, shot (one of the sorting options) so that I can work through the scene from start to end but Resolve doesn't seem to be sorting these correctly.