[v3] The order method doesn’t seem to work with surround

[maximepvrt]

Environment

• Operating System: Darwin
• Node Version: v20.18.0
• Nuxt Version: 3.15.1
• CLI Version: 3.18.2
• Nitro Version: 2.10.4
• Package Manager: [email protected]
• Builder: -
• User Config: devtools, features, future, modules, colorMode, ui, runtimeConfig, content, routeRules, nitro, css, plausible, $production, linkChecker, sitemap, compatibilityDate
• Runtime Modules: @nuxt/[email protected] (35d9af7), @nuxt/[email protected] (85010c1), @nuxt/[email protected], @nuxtjs/[email protected], @vueuse/[email protected], @nuxtjs/[email protected]
• Build Modules: -

Reproduction

1. I have two articles in my collection:
   • 1.first-article with a date field set to 2024-01-01.
   • 2.second-article with a date field set to 2025-01-01.
2. I want to sort these articles using .order('date', 'DESC').
3. Despite specifying this order, the sorting doesn’t respect the date field and seems to rely on the stem instead.

Describe the bug

While using queryCollectionItemSurroundings, it seems that the order method has no effect on the sorting of results. The sorting always appears to be based on the stem field, regardless of the criteria defined via order.

Additional context

No response

Logs