How can I find edited and unfulfilled orders using Graph QL?

[HelpDigital]

Hi 

I have a one-time need to search my store for any unfulfilled orders that have been edited and line items removed/replaced.

As this filter / search isn't available in the UI, I wondered if I could run a Graph QL query in GraphiQL editor to find a list of orders. I can then manually check them.

I believe the fulfillable_quantity value is '0'  if a line item has been removed (prior to fulfillment). So I was hoping the query would be a simple as looking for all line items in unfulfilled orders with fulfillable_quantity=0 

Or is there a better field that indicates an order's line items have been edited?

I'm not too familiar with writing graph QL - would anyone be able to give me a starter for this query script?

I only require a list of order numbers that are potentially affected so that I can manually check them. 

Many thanks,

Leo

[gr_trading]

Hi @HelpDigital ,

I worry about any query available, which can fulfill your request. But you can build a utility using shopify webhooks and add a tag to order whenever any edit happens to order.

Ping me if you need more clarity for flow.

[HelpDigital]

Thanks - but this is a once-only requirement to deal with orders already edited due to the failure of a 3rd party system / webhook.

I will add tags to edited orders in future to make this process easier.

Thanks,

Leo