I have a these tables:
Client: id / name …
Equipment : id / name / model/ client_id
Project: id / name / client_id / status
Service: id / description / project_id / equipment_id
The issue I have is with Service. When i press on project_id i see all the projects in the system. I am trying to filter them like this : Project if status == open and if client.id == equipment.clent_id
In shot show only the projects that status open from the client that the equipment belongs to or project.
Any help is appreciated it .
LinkedIn
Twitter
