New External Sorting doesn't function properly

Bryan

Hi there,

The new simple mode for External sorting is not functioning correctly

https://docs.xano.com/working-with-data/functions/database-requests/query-all-records/external-query-manipulation/external-sorting

Also just an FYI, the example JSON code you have provided in the docs isn't a valid JSON.

The structure of the JSON looks the same on both old and new, and when I test it on the classic version it functions correctly, but it doesn't on the simple version.

Ray Deck

Got it! I think the documentation is just wrong in this case. The correct shape (or at least what works for me) is:

[{"sortBy": "fieldName", "orderBy":"desc"}]

Note that the wrapping object and "sort" key are absent from the above!

(Click-through in Xano: create array, then push a blank object, on which one sets the sortBypath to "fieldName" and the orderBy path to "desc")

This kind of tricky business between-the-lines of the docs comes up a lot in our daily State Change Pro office hours.

Ray Deck

Assuming you want help from the community - can you show what's going sideways for you via screenshots or Loom? The JSON you're using, the query it's going into etc?

Bryan

Thanks Ray, I didn't bother with a video since it seems like a pretty blatant bug, but in hindsight that definitely would have helped.

Here's the video - https://www.loom.com/share/151021194d29434095bce7b2cab55f84

Bryan

Ah brilliant! Thanks @Ray Deck, that worked!

Can't believe I didn't try that variation out.

Leo Med

This was going to take me out of my mind😩. Things stop working as expected since I decided to use the new "simple" mode. Thanks @Ray Deck for the solution, they should consider updating the doc, already more than a month since this is reported.

Stefan Pointecker

PLEASE update the docs! this just cost me hours of my life. @Michael Udinski