How do I find outstanding orders after a specified date?

Retired Boards Appdev Graphql Basics And Troubleshooting
1

I would like to query all outstanding orders after 01/01/2023 by batch operation, what should I do?

Our definition of an outstanding order is
fulfillment_status = none/partial (not delivered/partially delivered)
financial_status = partially_paid, paid, partially_refunded (part-paid/part-paid/part-refunded)

2

You can use the GraphQL API to query orders and use an argument for after, as well as filter with financial_status and fulfillment_status,

3

My query looks like this. What’s wrong with it?

One more question, I want to query all the details of the order, but I don’t want to list all the attributes. What should I do?


orders(query: "created_at:>=2023-01-01 AND (financial_status:PARTIALLY_PAID OR financial_status:PAID OR financial_status:PARTIALLY_REFUNDED OR (NOT fulfillment_status:FULFILLED))") {...}