[GraphQL API] Cannot query fulfilled orders on Remix Node app

Shopify Apps
1

Hi, I am developing a custom app that contains a Polaris Index Table component displaying orders from the last 60 days. The Index Table have some predefined tabs that filter the orders by ‘Unfulfilled’ and ‘Fulfilled’ status by setting the search params, which in turn, will be passed into the GraphQL orders query.

example: Clicking on the ‘Fulfilled’ tab

url: ?fulfillment_status=shipped

GraphQL query:

orders(first: 100, query: "fulfillment_status:shipped") {
          edges {
            node {
              id
              customer {
                firstName
                lastName
              }
              name
              customAttributes {
                key
                value
              }
              shippingLine {
                title
              }
              displayFulfillmentStatus
              shippingAddress {
                city
                countryCodeV2
                formatted(withCompany: false, withName: false)
                provinceCode
                zip
              }
            }

however, the Order query always returns an empty array whenever query: “fulfillment_status:shipped” is passed into the query. This only happens on the production store that I installed my app to. On my dev store, Order query still returns the correct data for fulfilled orders.

I tried pasting the same query to Shopify GraphiQL App on my production store, the correct data is still being returned.

Have any encounter this problem? What have I done wrong here?