I am trying to run a query to receive an email for all unfulfilled and partially fulfilled orders that are open longer than four days. The query is working but I am receiving more than just my open ones. This is what i am using.
created_at:<=‘{{ scheduledAt | date_minus: “4 days” }}’ AND (fulfillment_status:unfulfilled OR fulfillment_status:partially_fulfilled) AND NOT (status:archived OR status:cancelled)