7 Replies Latest reply on Jan 20, 2016 1:44 PM by shawkins

    filter on child table not working

    prashanthi1

      Hello,

       

      We have modelled two tables and joined them by a foreign key relationship.

      url of type - odata/parentTable(primaryKey)/ChildTable(primaryKey) is fetching us the data that is having the primary key of both child and parent table.

       

      But when we do a filter on any field of child table, the foreign key relationship does not exist. It is resulting the data that is filtered out on the child table only.

       

      How do we get results that will give us data that is related by foreign key relationship and filter on child table.

       

      Thanks in advance,

      Prashanthi.