I’m working on a website for a sports club and they have lots of different categories and teams:
* Category 1 * Team 1 - Reports * Team 2 - Reports * Category 2 * Sub-Category 1 * Team 1 - Reports * Team 2 - Reports
Every team has a
Reports resource where match reports should be displayed. In order so users don’t have to navigate through the resource tree, I have created a custom package with MIGXdb to outsource all the reports into their own menu. Within that package, I let the user create reports and select the Category, Sub-Category and Team for it through resource related DynamicDropdownTVs.
Now, ideally I would like to have just one template to display the reports for the currently visited
Reports-resource of any Team. I’ve started using
[[migxLoopCollection]] to get those reports to the front-end and I guess I need to specify the
&where property in that call to get only the reports for the selected Team. I’m a little stuck here though.
If I’m not mistaken
&where needs JSON format, which I’m not yet too familiar with. How would I only get the reports shown, which have been selected for that Team while creating it?
If there is any other, easier solution to my process, I would love to hear it as well!
Thanks alot for any help!