Filter on fulfilled orders

Highlighted
New Member
1 0 0

I'm having a lot of trouble filtering out unfulfilled orders.

I'm using the graphql admin api. This query:

{
    shop {
        orders(first: 20,query: "created_at:>2020-10-12 created_at:<2020-10-20 fulfillment_status:fulfilled") {
            edges {
                node {
                    name
                    displayFulfillmentStatus
                }
            }
        }
    }
}

 Includes this order in the results:

{
    "node": {
        "name": "#REDACTED",
        "displayFulfillmentStatus": "UNFULFILLED"
    }
},

I've tried these query strings, too:

"created_at:>2020-10-12 AND created_at:<2020-10-20 AND fulfillment_status:fulfilled"
"created_at:>2020-10-12,created_at:<2020-10-20,fulfillment_status:fulfilled"
"created_at:>'2020-10-12' AND created_at:<'2020-10-20' AND fulfillment_status:'fulfilled'"
 
None of them work. They all include the unfulfilled order in the result set.
Please tell me what I'm doing wrong.
Thanks!
0 Likes
Highlighted
Shopify Partner
661 46 132

Please check this link out and let me know if it helps --> https://community.shopify.com/c/Shopify-APIs-SDKs/GraphQL-query-for-fulfilled-orders-amp-other-filte.... I recall running into this quirk and changing the criteria helped! 

0 Likes