Many to Many Relathionship in a Grid

2 posts, 0 answers
  1. Matteo
    Matteo avatar
    2 posts
    Member since:
    Mar 2016

    Posted 31 Mar Link to this post

    we have this kind of problem:

    We have a database situation as described in the attached screenshot: We have one Request Table, one User Table and an Assignment Table that manage the many to many relationship of the first two tables.

    We also have a kendoGrid bounded to the Request Table, and we need to filter data showing only the Request assigned to a specific user.

    We are trying to use datasouce.filter (http://docs.telerik.com/kendo-ui/api/javascript/data/datasource#configuration-filter) but we can only filter fields from the Request Table and not from the  Assignment Table.

     

    Is there a way to filter a grid using field from a related table?

    Any answers will'be a great help for us.

    Thank you.





     

  2. Dimiter Topalov
    Admin
    Dimiter Topalov avatar
    353 posts

    Posted 04 Apr Link to this post

    Hello Matteo,

    I can advise you to check out the following topics from our forums:

    http://www.telerik.com/forums/working-with-manytomany-relations

    http://www.telerik.com/forums/grid-with-many-to-many-relationship

    http://www.telerik.com/forums/multiselectfor-with-mvc-ef-many-to-many-relation

    I hope this helps.

    Regards,
    Dimiter Topalov
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. UI for ASP.NET MVC is VS 2017 Ready
Back to Top