Query Orders Where Created at Falls within A Certain Range

Retired Boards Appdev Graphql Basics And Troubleshooting
1 
query ($cursor: String, $query: String!, $lineItemsCursor: String) {
      orders(first: 5, sortKey: CREATED_AT, query: $query, after: $cursor) {
        pageInfo {
          hasNextPage
        }
        edges {
          cursor
          node {
            id
            createdAt
            lineItems(first: 50, after: $lineItemsCursor) {
              pageInfo {
                hasNextPage
              }
              edges {
                cursor
                node {
                  id
                  quantity
                  variant {
                    id
                    displayName
                    sku
                    inventoryQuantity
                  }
                }
              }
            }
          }
        }
      }
    }

Above is the query I am using to query orders using GQL. It works when I set the query string to “created_at:>=2022-01-01” but when I try “created_at:>=2022-01-01 and created_at:<=2022-01-31” I get 0 results. Any insight into what I am doing wrong with the query string would be helpful.

2

Hey @tamara_mcd can you try a query using this syntax and let us know if it works? Removing the sortKey param may work:

orders(first:20, query:"created_at:>2019-12-05T10:10:10Z created_at:<2021-12-09T12:12:12Z")

I was able to test a similar query using this syntax and it pulled orders created between the requested dates in the response.

Hope this helps!