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.ĬONSTRAINT "PK_GM" PRIMARY KEY ("GM_UID")) ĬOMMENT ON TABLE "VXVIEW_EXEC"."GM_GUI_MENU" IS 'Menu items for a dynamic list that builds the VX-VIEW hierarchical menu' ĬOMMENT ON COLUMN "VXVIEW_EXEC"."GM_GUI_MENU"."GM_UID" IS 'Unique identifer of a menu item created as a dynamic list entry' ĬOMMENT ON COLUMN "VXVIEW_EXEC"."GM_GUI_MENU"."GM_PARENT_GM_UID" IS 'Unique identifer of a menu item created as a dynamic list entry' ĬOMMENT ON COLUMN "VXVIEW_EXEC"."GM_GUI_MENU"."GM_LABEL" IS 'Text to appear as list Entry' ĬOMMENT ON COLUMN "VXVIEW_EXEC"."GM_GUI_MENU"."GM_TARGET" IS 'Target URL to branch to when list entry is selected' ĬOMMENT ON COLUMN "VXVIEW_EXEC"."GM_GUI_MENU"."GM_IS_CURRENT_LIST_ENTRY" IS 'Controls the behavior of the list entry. 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?
#Apex sql data dictionary how to
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.
I have a table that stores my list entries which I want to query and also maintain outside of the APEX data dictionary tables. I want to pass the list name to the menu object and have a multi- root, multi level menu structure. 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.
1.7K Training / Learning / Certificationįirst question.is it possible to create a dynamic list object with hierarchical list entries in APEX 5.1? if so then read on.165.3K Java EE (Java Enterprise Edition).7.8K Oracle Database Express Edition (XE).3.7K Java and JavaScript in the Database.
0 kommentar(er)
