Good morning, I have had a problem, I am working on a module in which I am trying to show only the users who are from a Region (Parent Department) and filter only their sub-departments.

We made a module to evaluate the department that are sub-deparment from that user.

We need assistance in order to create filter views to Employees only to visualize the database of people that are inside their department and their sub-department.

How can we enable that?

I made this code so far:

§datas = User: :orderBy(" id' , 'DESC")-›where( "company_id' ,'=', '1')
›whereas ( 'employeeDetail.department', function($query) { $query - ›where(' id' =', user() - ›employeeDetail-›department_id)
›orWhere 'parent id' , user()-»employeeDetail-›department id);
})
-›paginate(10);