GraphQL Orders bug report: Timezone support for processed_at

nicolas-grasset
Tourist
9 0 1

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

 

Replies 3 (3)
_JB
Shopify Staff
Shopify Staff
836 100 219

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.

JB | Solutions Engineer @ Shopify 
 - Was your question answered? Mark it as an Accepted Solution
 - To learn more visit Shopify.dev or the Shopify Web Design and Development Blog

nicolas-grasset
Tourist
9 0 1

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
Shopify Partner
83 10 27

Hi JB,

How is issue ? We encountered same issue 😅