tl;dr: my Orders GraphQL query works just fine when sorting by CREATED_AT, but freaks out and won't return the requested number of orders per page when sorting by TOTAL_PRICE or ORDER_NUMBER, instead returning just a few or 0.
I have a Next.js app that fetches orders from the Admin API (version 2023-07) and displays them. I have a sorting function enabled and allow sorting by CREATED_AT, TOTAL_PRICE, and ORDER_NUMBER. I fetch the orders from the API using a GraphQL query (below) and this works just fine when I make a request for orders sorted by CREATED_AT, both in ascending (reverse: false) and descending (reverse: true) order. If I request 10 items/page, I get 10 items/page, all correctly sorted.
However, if I use TOTAL_PRICE, for example, changing nothing else about the query except the sortKey, the first page returned in reverse/descending order only returns two results, despite having dozens of orders to sort. When sorted in non-reverse/ascending order, I don't get any results at all. The pagination cursors work about half the time, and sometimes they'll bring me to a new page with different orders on it after clicking a few times, but usually not.
So, it seems like when sorting by TOTAL_PRICE, I'm somehow not getting the requested count of products per page. The same is true for ORDER_NUMBER, but only when I query with reverse: false. The exact same query works perfectly to sort orders by CREATED_AT, both in reverse and non-reverse order, so it seems that there's specifically an issue with the sortKey.
Weirdly, though, when I try the exact same query in the GraphiQL app, I get the correct results--10 per page every time. I've even copy-pasted that exact same query, with hard-coded variables, into my app and I get the same issue. I'm using the most recent version of the API (2023-07) and all the most up-to-date Shopify npm packages (@shopify/shopify-api 7.5.2, @Shopify/app 3.8.1).
Here's the main query I'm using, copy-pasted from my app (it's identical to the working query in the GraphiQL app).
This query works perfectly in GraphiQL, but in my app, it returns an empty edges array of orders. If I increase "first" to 50, I get 4 orders. 100 gets me 30 orders. 200 gets me 41, and so on. When I sort by CREATED_AT, this exact query gets me 10 orders per page. When I add in some dynamic variables for next/previous pagination, it works exactly as expected with CREATED_AT, but, again, not at all as expected for TOTAL_PRICE.
What could be the issue here? Am I being colossally unobservant and missing something obvious, or is this a bug nobody's talking about?