I am building a student evaluation system. The teachers login and I have a page with a form for each class. the teacher selects the student and fills out the evaluation and submits it to a collection for that class. parents can have multiple students in multiple classes. I currently have a collection for each class evaluation form. there are 14 classes. is there a way to filter all 14 collections in a single table? or is my approach incorrect? do I need to query each collection and combine and filter the results? how would I do this?
top of page
Important forum update
This forum is migrating to one unified Wix community forum starting July 26th, and will be read-only during the process.
![feature fixed.png](https://static.wixstatic.com/media/3bfa8a_f845e1016b8a49758acdd6edd6610c3b~mv2.png/v1/crop/x_0,y_2,w_852,h_508/fill/w_104,h_62,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/feature%20fixed.png)
Wishlist Page is the official platform for requesting new features. You can vote, comment, and track the status of the requested features.
bottom of page
Alex, you asked if your approach is incorrect. Most people experienced in relational database setups would have a very different approach. You can probably get yours to work with combined queries, but I'm assuming that you will want to be able to query by a certain parent, teacher, or student. Think that through to make sure you can do that with the result set of the combined query.
The relational database purist approach would have you creating evaluations, class, teacher, parent, and student collections. There would not be a collection for each class, but keys that refer back to the class, teacher, parent, and student collections from an evaluations collection. In other words, evaluations would be the large collection in your database, and the other collections would essentially be lookup tables.
I don't have enough information about your data requirements to be any more specific. If this sounds too complex, then don't get bogged down it. I mention this alternative only because you wondered if you have the correct approach.
Hello? Anyone?