Many to Many Relathionship in a Grid

[Matteo]

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.





 

[Dimiter Topalov]

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