Chapter 1 of the design guidelines includes a list of the comparison operators to be supported on the filter query string. Both variants should be supported, gt (greater than) and gte (greater than or equal), similarly lt and lte. So the issue now is how to translate end-user (human) input into the query string. In my view, date ranges should be interpreted expansively, i.e. from the beginning of the from date (T00:00:00.000) to the end of the to date (T59:59:59.999). These are local times, and will likely need to be translated to UTC before applying the query, assuming that persisted dates are stored in UTC.
Hope it helps.
------------------------------
Jonathan Goldberg
Amdocs Management Limited
Any opinions and statements made by me on this forum are purely personal, and do not necessarily reflect the position of the TM Forum or my employer.
------------------------------
Original Message:
Sent: Sep 28, 2023 01:42
From: Mandar Limaye
Subject: TMF677 Filter criteria end date
Hello Matthieu,
Thank you for direction, Let me check,
Best Regards
ML
------------------------------
Mandar Limaye
Tech Mahindra Limited
Original Message:
Sent: Sep 27, 2023 11:12
From: Matthieu Hattab
Subject: TMF677 Filter criteria end date
Filtering and attribute selection rules are described in the TMF630 (TMF REST Design Guidelines) document
------------------------------
Kind regards,
Matthieu Hattab
Lyse Platform
Original Message:
Sent: Sep 27, 2023 04:04
From: Mandar Limaye
Subject: TMF677 Filter criteria end date
Hello
I have a query related to filtering on date, What is the convention whether the data returned should include the end date or it is one day less than end date?
I mean if date range is from 5th Sep 2023 to 27th Sep 2023 so data should include both dates or exclude 27th Sep 2023.
Documentation does not specify on this?
Thank you in advance.
ML
------------------------------
Mandar Limaye
Tech Mahindra Limited
------------------------------