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

Wrong result with bidirectional relationship

XMLWordPrintable

      From the forum post, two tables that relate to each other:

      EmployeeMasterEntity (PK EmployeeID, FK Departments)
      OrganizationalUnitEntity (PK OrganizationalUnitID, FK Managers)

      With data like:

      EmployeeMasterEntity
      EmployeeID Department
      1 10000001
      2 10000002
      3 10000001

      OrganizationalUnitEntity
      OrganizationaUnitID UnitManager
      10000001 1
      10000002 2
      10000003 2

      Will not return the correct results for a query such as:

      http://localhost:8080/odata4/TestOdata.1/InterlemView/EmployeeMasterEntity(3)/Departments?$format=json

      This is due to using the wrong relationship for the navigation.

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: