Skip to main content
Solved

How to export Navigator to Excel (IFS Cloud)

  • February 26, 2025
  • 2 replies
  • 157 views
F
Do Gooder (Customer)
Forum|alt.badge.img+2

I did it once a while ago but forgot how to do it again. I am looking to extract the navigator items to excel in a format as such:

 

>Scheduled Tasks Conversion 1 MENU
>My Administration 1 MENU
>My Administration>Basic Data Translation 2 PAGE
>My Administration>Notifications 2 PAGE
>My Administration>My Tasks 2 PAGE
>My Administration>My Lobbies 2 INTERNAL
>My Administration>My Industry Lobby Results 2 PAGE
>My Administration>Subscription 2 PAGE
>My Administration>Subscriptions 2 PAGE
>My Administration>Scheduled Tasks 2 MENU
>My Administration>Scheduled Tasks>New Database Task Schedule 3 ASSISTANT
>My Administration>Scheduled Tasks>Database Task Schedule 3 PAGE
>My Administration>Scheduled Tasks>Database Task Schedules 3 PAGE
>My Administration>Scheduled Tasks>New Database Task Chain Schedule 3 ASSISTANT
>My Administration>Scheduled Tasks>Database Task Chain Schedule 3 PAGE
>My Administration>Scheduled Tasks>Database Task Chain Schedules 3 PAGE

Best answer by Makede

Hi ​@fbcndaniel 

for IFS Cloud you can maybe run following statement in a quick report or something like this:

SELECT LPAD(' ', (LEVEL - 1) * 3, ' ') || n.label navigator_node,      
       DECODE(n.entry_type, 'MENU', '', 'LOBBY', '', n.projection) projection,       
       INITCAP(n.entry_type) entry_type,       
       Pres_Object_Description_API.Get_Description(DECODE(n.entry_type, 'LOBBY', 'lobbyPage' || n.page), 'en') description,      
       DECODE(n.entry_type, 'LOBBY', 'lobbyPage' || n.page) pres_object,      
       LEVEL,       
       p.label PARENT,       
       n.label child
FROM   fnd_navigator_all n,       
       fnd_navigator_all p
WHERE  p.id(+) = n.parent_id
CONNECT BY PRIOR n.id = n.parent_id
START  WITH n.parent_id = 0
ORDER  SIBLINGS BY n.sort_order

Best regards

Martina

    2 replies

    M
    Hero (Employee)
    Forum|alt.badge.img+11
    • Makede
    • Hero (Employee)
    • 106 replies
    • Answer
    • February 27, 2025

    Hi ​@fbcndaniel 

    for IFS Cloud you can maybe run following statement in a quick report or something like this:

    SELECT LPAD(' ', (LEVEL - 1) * 3, ' ') || n.label navigator_node,      
           DECODE(n.entry_type, 'MENU', '', 'LOBBY', '', n.projection) projection,       
           INITCAP(n.entry_type) entry_type,       
           Pres_Object_Description_API.Get_Description(DECODE(n.entry_type, 'LOBBY', 'lobbyPage' || n.page), 'en') description,      
           DECODE(n.entry_type, 'LOBBY', 'lobbyPage' || n.page) pres_object,      
           LEVEL,       
           p.label PARENT,       
           n.label child
    FROM   fnd_navigator_all n,       
           fnd_navigator_all p
    WHERE  p.id(+) = n.parent_id
    CONNECT BY PRIOR n.id = n.parent_id
    START  WITH n.parent_id = 0
    ORDER  SIBLINGS BY n.sort_order

    Best regards

    Martina

    F
    Do Gooder (Customer)
    Forum|alt.badge.img+2
    • fbcndaniel
    • Author
    • Do Gooder (Customer)
    • 6 replies
    • February 27, 2025

    Thanks to your example, I was able to get the desired output from the Quick Report using this:
    SELECT SYS_CONNECT_BY_PATH(n.label, '>') "NAVIGATOR PATH",
           LEVEL "LEVEL",
           UPPER(n.entry_type) "TYPE"
    FROM   fnd_navigator_all n
    CONNECT BY PRIOR n.id = n.parent_id
    START WITH n.parent_id = 0
    ORDER SIBLINGS BY n.sort_order


    Terms & ConditionsCookie settingsAccessibility statement