Filter aggregate when we have one to many relationship
Application Type

I have Employee table and Hobbies table with many to many relationship. In one of the screen I am showing the employee list. There is one dropdown for Hobby which filters the Employee based on selected hobby. 

I want to know what is the optimised way to filter employee based on their filter when they have many to many relation ship and the result should not have duplicate values. This is quite easy when we have one to many relationship but not in many to many. Is the SQL is last option ?




Hi Pankaj,

Please  find attached OML file.
Hope this will help you :)

Rahul Jain


This Solution Works for the sample oml but in my main project it still shows the duplicate values so used group by for the columns then it worked.


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.