Hello John,

Thank John for this info. I admit it's not easy to make this integration because there is some concatenation of different criteria inside your query. This depends on Session, banned users, and so on.

Let me know if it is possible from your side to indicate me precisely where I could integrate my query:

SELECT DISTINCT o.user_id FROM $ProjectMemberList o RIGHT JOIN $ProjectList p ON o.project_id=p.project_id WHERE (p.user_id=$user_current_id)

I have my list of users in $ProjectMemberList table. Each row of this table defines the user_id and the project_id he belongs to.

The $ProjectList table defines the project_id and the project owner who is the project manager.

This query searches all users (project team members) working on differents projects where to the current user is the project manager (i.e. $user_current_id).


Nota: I see that for the private messages, I got also the same request.

Thanks in advance.
Regards