We have our articles organized as shown below - the main Producers category has a subcategory for each Producer, which then has a category for each of their Programs. I've been tinkering with the dozens of options in a Joomla Category List, to list all the grandchild categories of a given category, but with no luck.
My inclination is to add a new view and related MVC files to
com_content, but that doesn't seem like a good idea, nor do I know how the installation package would do that.
In short, i'd like a page that displays all the categories (not articles) that are grandchild categories of Producers. I'm pretty sure that the core content component doesn't handle this, so am looking for some "best practice" approach, or perhaps a known extension that might do the trick.
Producers (category) -> John Doe (child category) -> Program1 Name (grandchild category) -> Article for Episode 1-1 -> Article for Episode 1-2 -> Article for Episode 1-3 -> Program2 Name (grandchild category) -> Article for Episode 2-1 -> Article for Episode 2-2 -> Mary Smith (child category) -> Program87 Name (grandchild category) -> Article for Episode 87-1 -> Article for Episode 87-2
Desired List of Categories to be displayed:
PROGRAMS PRODUCER EPISODES Program1 John Doe 3 Program2 John Doe 2 Program87 Mary Smith 2