GetOrderData of "Partially Fulfilled", but it does NOT works

[EunorauEbikes]

Advanced Query:

“created_at:<=‘{{ scheduledAt | date_minus: “21 days” }}’ AND created_at:>=‘{{ scheduledAt | date_minus: “60 days” }}’ AND (fulfillment_status:unfulfilled OR fulfillment_status:Partially_fulfilled) AND NOT status:cancelled AND NOT financial_status:refunded AND NOT chargeback_status:needs_response AND NOT chargeback_status:under_review”

I need to get order summary which meet all below conditions:

1, Fulfilled status: “Unfulfilled” or “Partially_fulfilled”

2, Financial_status: NOT “refunded”

3, Chargeback Status: NOT “needs_response” AND NOT “under_review”

But, After the flow runs, it count "0"orders. so i wanna know how to write the right code, or where above code need to correct. thank u.

[paul_n]

Docs for filters are here https://shopify.dev/docs/api/admin-graphql/2025-01/queries/orders#argument-query

Typically, I set filters one by one and I use GraphiQL so that I can quickly look at the results. Looking at your query, I think your fulfillment_status filter should be filtering on “partial” not partially_fulfilled. But there might be other errors in your logic/operators.

[EunorauEbikes]

“fulfillment_status filter should be filtering on “partial” not partially_fulfilled”

Thank you for the important clues you provided. I have modified the code and am testing it. Thank you

As for you said “But there might be other errors in your logic/operators”, because i’m a newbie, and don’t know how to test and modify it, so keep it as before. hope anyone else will help me out. thanks in advance