Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4032 Olingo V4
  3. TEIID-4110

Odata - date functions does't accept date string as a parameter

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Done
    • Icon: Major Major
    • 9.0, 8.12.5
    • None
    • OData
    • None

      Date functions year, month, day, hour, minute and second doesn't accept date string(DateTimeOffset) as a parameter.

      Reference service which supports OData V4:
      ULR: http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=month(2001-01-01T00:01:01.01Z) eq EmployeeID
      Result: Employee with ID 1

      URL: http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter=month(2001-01-01T00:01:01.01Z) eq intkey
      Result: {"error": {"code": null, "message": "TEIID30069 The function 'MONTH' has more than one possible signature." }}
      Expected result: Entity with intkey 1

              rhn-engineering-rareddy Ramesh Reddy
              msanitra Michal Sanitrak (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: