APEX 5.1
Oracle 12c
First question...is it possible to create a dynamic list object with hierarchical list entries in APEX 5.1? if so then read on...
I'm trying to get my head around how to build a hierarchical dynamic list so I can use it as a menu in APEX 5. I want to pass the list name to the menu object and have a multi- root, multi level menu structure. I have a table that stores my list entries which I want to query and also maintain outside of the APEX data dictionary tables. Given the standard SQL for dynamic lists, I don't understand how to set up the the parent child relationship for multiple levels? The "Level" column in the SLQL will give you the level of the list entry but how do I link it back to a parent in the list entries like in the attributes of a static list. for example If I have 2 parent entries FRUIT and ANIMAL and 4 children entries, namely, APPLE, ORANGE, DOG, CAT how do I associate the children with the correct parent in my SQL?
If there is another way of creating a hierarchical APEX 5.1 menu object from entries in an external table then please let me know.
thanks in advance
PaulP