Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3671

filter on child table not working

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 8.12, 8.11.4, 8.7.5
    • Component/s: OData
    • Labels:
      None

      Description

      Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13.

      Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22'

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jolee Johnathon Lee
                Reporter:
                prashanthi1 Prashanthi Kairuppala
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: