Open APIs

 View Only
  • 1.  TMF677 Filter criteria end date

    TM Forum Member
    Posted Sep 27, 2023 09:12

    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
    ------------------------------


  • 2.  RE: TMF677 Filter criteria end date

    TM Forum Member
    Posted Sep 27, 2023 11:13

    Filtering and attribute selection rules are described in the TMF630 (TMF REST Design Guidelines) document



    ------------------------------
    Kind regards,

    Matthieu Hattab
    Lyse Platform
    ------------------------------



  • 3.  RE: TMF677 Filter criteria end date

    TM Forum Member
    Posted Sep 28, 2023 01:42

    Hello Matthieu,

    Thank you for direction, Let me check,

    Best Regards

    ML



    ------------------------------
    Mandar Limaye
    Tech Mahindra Limited
    ------------------------------



  • 4.  RE: TMF677 Filter criteria end date

    TM Forum Member
    Posted Sep 28, 2023 10:49

    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.
    ------------------------------