GraphQL Orders bug report: Timezone support for processed_at

[nicolas-grasset]

Hi,

We have noticed an issue, most likely a bug, preventing us from querying orders by processed_at time. As you can see below, the time portion is ignored and I can't find a way to get it working. Note that the same syntax will work fine for created_at or updated_at and clearly the date portion of processed_at is read properly.

/admin/api/2020-01/graphql.json

Accept: */*
X-Shopify-Access-Token: *************
Accept-Encoding: gzip, deflate
Content-Type: application/graphql
Accept-Language: en-us

query {
  orders(query: "processed_at:>='2019-01-25T10:00:00Z' processed_at:<='2019-01-26T07:59:59Z'",first: 1, sortKey:PROCESSED_AT) {
    edges {
      cursor
      node {
        id
        createdAt
	processedAt
      }
    }
  }
}

{
    "data": {
        "orders": {
            "edges": [
                {
                    "cursor": "eyJsYXN0X2lkIjo4Mjc2MTYxMzMxODIsImxhc3RfdmFsdWUiOiIyMDE5LTAxLTI1IDA4OjQ1OjQ0In0=",
                    "node": {
                        "id": "gid://shopify/Order/827616133182",
                        "createdAt": "2019-01-25T08:45:44Z",
                        "processedAt": "2019-01-25T08:45:44Z"
                    }
                }
            ]
        }
    },
    "extensions": {
        "cost": {
            "requestedQueryCost": 3,
            "actualQueryCost": 3,
            "throttleStatus": {
                "maximumAvailable": 2000,
                "currentlyAvailable": 1997,
                "restoreRate": 100
            }
        }
    }
}

Thanks,

/Nicolas

[_JB]

Hey Nicolas,

Thanks for reporting this. Our developers are aware of the issue and are currently working on a fix. I'll post back here once I have an update on the fix.

[nicolas-grasset]

Hi JB,

I hope your team is healthy and not too affected by the Covid-19, even though we all are.

Just a nudge to see if the solution has been released or if there's any indication of when we can expect it.

Thanks!

/N

[camelmasa]

Hi JB,

How is issue ? We encountered same issue 😅