Hello Everyone,
I’m experiencing difficulty with filtering orders by date using the TastyIgniter API. I attempted to filter orders using the order_date field with the following request:
orders?filter[status_id]=1&filter[order_date]=2023-09-21T00:00:00.000000Z
This query returns all orders instead of those from the specified date. I also tried filtering by a specific 24-hour period using gte and lte operators:
orders?filter[status_id]=1&filter[order_date][gte]=2023-09-21T00:00:00.000000Z&filter[order_date][lte]=2023-09-21T23:59:59.000000Z
This approach didn’t work either. Is there a particular format or method for date filtering in TastyIgniter that I might be missing? Any advice or solutions would be greatly appreciated.
Thank you for your help!
Regards
Darshan Hiranandani