Urgent! - Filter by changedDate in order table suddenly not working anymore!

[Tom Stude]

Hi! 

Since 2. of June 2023. filter for changedDate not working anymore.  The query below now gives me all orders in database and not only the orders for the last 3 days! Before this date the query worked as expected. 
 

query data {
  useCompany(no: xxx) {
    order(
      first: 500
      after: ""
      filter: {changedDate: {_gte: 20230603}}
    ) {
      pageInfo {
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      totalCount
      items {
				changedDate
        orderNo
        changedDateTime
        createdDateTime
      }
    }
  }
}

I have checked the result for changedDate from the query and this date is correct: Ex: 

       {
            "changedDate": 20140103,
            "orderNo": xxxx,
            "changedDateTime": "2014-01-03T07:26:00",
            "createdDateTime": "2014-01-01T07:13:00"
          },

[Tom Stude]

Thanks! now it works again!

[Marius Bancila]

I can confirm this is not working anymore. I'll investigate and fix the issue. 

What works for now is this:

filter: {changedDateAsDate: {_gte: "2023-06-03"}}

[Tom Stude]

Is this something that will be fixed quickly, or could it take time? And which method would you prefer us to use / has the least impact on the server? Filtering on the integer value changedDate or on the date field changedDateAsDate?

[Marius Bancila · Accepted solution]

The fix for this is already in production.

Filters like the ones you shown should work again as expected.