GraphQL Query Orders not returning all orders on some queries

Retired Boards Appdev Graphql Basics And Troubleshooting
,
1

I’ve got an issue where I can query and get all the orders. But on some query parameters, the counts drop inexplicably. Here’s my simple base graphql query:

query getOrders($myquery: String!) {
      orders(first:250, query: $myquery) {
        edges {
            node {
                id
                createdAt
                displayFinancialStatus
                cancelledAt
            }
        }
      }
    }

Now here are some various query parameters I pass in and the records returned (bolded make no sense to me)

“query” : “created_at:>‘2022-05-01T23:39:20Z’” : returns 250

“query” : “created_at:>‘2022-05-01T23:39:20Z’ and created_at:<‘2024-10-25T23:39:20Z’” : returns 10

“query” : “created_at:>‘2022-05-01T23:39:20Z’ and -financial_status:refunded” : returns 10

“query” : “-financial_status:refunded” : returns 250

“query” : “-financial_status:refunded and -status:cancelled” : returns 10

The bolded make no sense. I checked orders that would show vs those that don’t and couldn’t find a difference. And I tried this on two different stores and same effect (differing counts) which makes no sense. Is the “and” not correct or something?

2

Hi， Mad

and should be uppercase in query ,otherwise it will not works .

pls try '“query” : “created_at:>‘2022-05-01T23:39:20Z’ AND created_at:<‘2024-10-25T23:39:20Z’”