Hi everyone, I need to transform a static menu (like the one you see in the gif) into a dynamic menu that reads data from the DB.
I created 2 tables: Categories and Pages where the PA_Categoria_ID field relates the menu items to the category.
I created the connect server to read the categories and pages and I thought of using a repeat inside the other to match the menu items to the reference category but I don't think it's the correct method.
The first repeat works correctly and shows the categories, but in the nested repeat I don't know how to set the filter for the PA_Category_ID field so that I only see the menu items of the correct category.
At the moment the result is that I have all the pages inside all the categories.
How would you handle this?