Orders - Created_at Query Questions

Topic summary

  • Problem: A user can’t retrieve an order (created 2023-10-01) using a GraphQL orders search with a created_at time window that should include it.

  • Query used: orders(first: 10, query: “created_at:>= ‘2020-09-26T00:00:00Z’ AND created_at:<=‘2023-10-25T23:59:59Z’ AND status=any”). The query returns an empty array despite the known order.

  • Attempted fix: A reply identified a syntax issue and advised changing status=any to status:any (correct search operator). After correcting to status:any, the query still returned no data.

  • Next steps: The helper requested app and store details via direct message for deeper troubleshooting; the original poster provided them.

  • Status: Unresolved in-thread; investigation continues privately. No confirmed cause or solution yet.

Summarized with AI on January 14. AI used: gpt-5.

Hi! i have a problem with getting data in period of time

i have an order created at 2023-10-01

i am trying to get info about it with this query

orders(first: 10, query: “created_at:>=‘2020-09-26T00:00:00Z’ AND created_at:<=‘2023-10-25T23:59:59Z’ AND status=any”)

and it returned empty array, but it should return the orders
can somebody explain what i am doing wrong ?

Hey @Denys_Slipko ,

Super close, I suspect status**=any might be your issue (try status:**any).

Let me know if you’re still not seeing anything.

my fault, i fixed status**:**any, but it still not working, no data.

Can you DM me app + store details?

Sure, i sent you a few messages.