%FilePath_Absolute and %Filepath_Relative

These are the meta variables used generally with File Classes.
Both of the help us in defining the path of the file. One of them is Absolute and other one is Relative.

I will not go much details about the syntax of the functions which use these variables.

I believe most of you might have put this question to your self when encounterd with below variables like what is Absolute path and Relative path.

 %FilePath_Absolute: We define the actual path on the server.
                                    We can place file on any folder path in the server.

Ex:- PS_HOME/user/filename.txt

%Filepath_Relative: This uses the system defined path.
                                  Files can be placed in the sub-folders beneath this path.
                                  System Defined paths are like PS_FILEDIR/PS_SERVDIR etc.

Ex:- PS_FILEDIR/filename.txt

SQL to find Navigation for a Given Process.

-- SQL to find Navigation for a Given Process.

The below SQL lists all the Navigations where the process is attached.

SELECT  A.PORTAL_URI_SEG2,
RTRIM(E.PORTAL_LABEL)
|| ' >> ' || RTRIM(D.PORTAL_LABEL)
|| ' >> ' || RTRIM(C.PORTAL_LABEL)
|| ' >> ' || RTRIM(B.PORTAL_LABEL)
|| ' >> ' || RTRIM(A.PORTAL_LABEL)
FROM PSPRSMDEFN A LEFT JOIN PSPRSMDEFN B ON B.PORTAL_NAME = A.PORTAL_NAME
AND B.PORTAL_OBJNAME = A.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN C
ON C.PORTAL_NAME = B.PORTAL_NAME AND C.PORTAL_OBJNAME = B.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN D
ON D.PORTAL_NAME = C.PORTAL_NAME AND D.PORTAL_OBJNAME = C.PORTAL_PRNTOBJNAME LEFT JOIN PSPRSMDEFN E
ON E.PORTAL_NAME = D.PORTAL_NAME AND E.PORTAL_OBJNAME = D.PORTAL_PRNTOBJNAME WHERE
A.PORTAL_URI_SEG2 IN (SELECT PNLGRPNAME from PS_PRCSDEFNPNL P WHERE P.PRCSNAME = < PROCESS_NAME >);

Note: Substitue Process Name in the < PROCESS_NAME >.