Hello, I have inherited a Symfony web app, er go I don't have much experience with Symfony so bare with me.
The problem is this I have currently 3 tables contacts, contactschool and schools, I didn't name the former and the latter. Contacts holds information for each teacher, principal, coach, etc. The reason for having contactshools is because there exists a many to many relationship between contacts and schools. A school has many teachers. A school only has one coach, but the coach can coach at many schools, a max of 12. The schools and contacts tables have id primary key fields and contactschool has a contact_id and school_id which in the scheme.yml file have been set as foreign keys to contacts' and schools' id fields respectively. The problem is this when I have a list of all the contacts how can I filter by school? I know in the myapp/modules/contacts/config/generator.yml I will need a filter: [] line but since there is no foreign key in the contacts table related to the schools or contactschool table, how can I add this filter? Is it the easiest way to write a custom filter that only filters on the contacts module. Thanks in advance, Chris --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
