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?