This content has been marked as final. Show 6 replies
To get multi-level list you need the Level item to contain a value, which in turn means the use of CONNECT BY.. START WITH clause. It like any other tree or hierarchical query.
You will find the example on the Create Dynamic Lists wizard's Create List page. It goes like this.
If your objective is to display the existing Tabs (hierarchical) as a List then you use the Apex Views. If you do not use Tabs then you might be better off using a custom table for the List(s).
Example 3 (using hierarchical SQL query): select level, ENAME label, 'f?p=&APP_ID.:1:'||:APP_SESSION||'::::P1_EMPNO:'||empno target, 'NO' is_current, '#APP_IMAGES#del.gif' image from EMP start with MGR is null connect by prior EMPNO = MGR order siblings by ENAME
Thank you for you response.
Only I need a list for the second level tabs since I have the first level on the top navigation area of my page template
As I understood, I wrote the following code for the list
In page 0, I created a list region with template (Vertical Unordered List without Bullets), however, it is not displaying anything!!
SELECT null, TABLABEL label, 'f?p=&APP_ID.:' || TABPAGE || ':'||:APP_SESSION||':::::' target, (CASE WHEN TABPAGE = :APP_PAGE_ID THEN 'YES' ELSE 'NO' END) is_current from MY_VW_TABS WHERE PTTABNAME in (select TAB_SET from APEX_APPLICATION_TABS where TAB_PAGE = :APP_PAGE_ID)
What is missing to get list displayed?