Forum

This content is now out of date.

Visit Our Community

How do I define a filter on a N:M relationship?


Hi,

I have a N:M relationship between 2 entities (for example, EMPLOYEE and DEPARTMENT)

I want to define a view that lists employees. This is a basic [quote="select field1,field2,field3 from employee">[/quote] query

On this view a need a "department" filter, but this field is NOT on the view (because one employee can belong to many departments)

How can I achieve so?

Many thanks

Jordi
Hi Jordi,

sorry but I don't understand....why can't you just join the EMPLOYEE & DEPARTMENT tables in the view. Then the DeptID will be available in reports to be used as a filter to restrict which employees are displayed?

regards,
Dave

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.