I want to build a search filter in symfony. I am using symfony 2.8. I have four table with respected entities. Table are
professional
professional_pets
professional_categories
professional_organization
professional_pets
table contain professionalId
and petId
for store the relation pet and professional.
same way the professional_categories
table contains professionalId
and categoryId
fields to store relation between professional
and Categories
. Same case with professional_organization
.
What I want that I want a dql query to filter professionals form professionals table if it is possible which can extract only those records from professional table which have relation with specific in professional_pet, professional_categories and professional_organizations.
In other work I want tho create filter for professinals in professionals table base on the if there is a relation sotre for them in professional_pet, professional_categories and professional_organizations tables.
I am attaching a snapshot of filter. Thanks for help in advance.