Filter Employee where employe project is active

Hello Everyone,
I am customizing the Employee and add the Project Employee Table
The project employee table have project and status field

In the employee_attendance_tool i have added the project filter.

I was able to get the list of employees under a project. However, if the employee has multiple projects. the employee will also be displayed multiple times according to the number of project it had.

My question is, how can i filter the employee list so that it will only display the employees uniquely with a specific project with an active status?

1 Like

This should help:

Overriding Link Query By Custom Script