GraphQL date filter does not seem to be working as expected

When I specify a query with the following: start_date_after: "2021-11-18T05:00:00+0000", start_date_before: "2021-11-18T07:00:00+0000" I received back items with the following start_dates: "2021-11-18T06:00:00+0000" and "2021-11-08T06:00:00+0000", shouldnt only one of these be returned? Here is a link to try the exact query yourself. Am I doing something wrong or misunderstanding?

Hello Justin, glad to see you join the community.

I can confirm that there's something wrong with the Timestamp field. I'll pass this over to the relevant teams and let you know when we have more information.

Thanks

Sounds good, thank you Pau!

1 Like

I have run into another "where" statement seemingly not working as expected. I am trying to get only active sales in this query

Hello, again, Justin. So reviewed your query once again and found that it's only retrieving one document because the Upcoming_saless Custom Type is a singleton. You're going to get the same result with the Dev_sales type. Is also a singleton.

So I guess what's happening here is that you're trying to retrieve only the elements inside the Group field that match your search, but the where argument searches inside documents. So what you need to do is add the Boolean field inside your documents, or perform the logic of this search in the front end of your app.