Friday, 7 November 2014

SQL To get query security tree navigation based on record name/node name  :


select a.tree_name
        ||'-->'||(select B.parent_node_name from PSTREENODE B where B.TREE_NODE=(select C.parent_node_name from PSTREENODE C where C.TREE_NODE=(select C1.parent_node_name from PSTREENODE C1 where C1.TREE_NODE=D.parent_node_name and C1.tree_name=D.tree_name and rownum=1 ) and C.tree_name=D.tree_name and rownum=1 ) and B.tree_name=A.tree_name and rownum=1 )
       ||'-->'||(select C.parent_node_name from PSTREENODE C where C.TREE_NODE=(select C1.parent_node_name from PSTREENODE C1 where C1.TREE_NODE=D.parent_node_name and C1.tree_name=D.tree_name and rownum=1 ) and C.tree_name=D.tree_name and rownum=1 )
       ||'-->'||(select C1.parent_node_name from PSTREENODE C1 where C1.TREE_NODE=D.parent_node_name and C1.tree_name=D.tree_name and rownum=1 )
       ||'-->'||(select B.parent_node_name from PSTREENODE B where B.TREE_NODE=A.parent_node_name and B.tree_name=A.tree_name and rownum=1 )
        ||'-->'||A.parent_node_name
        ||'-->'||A.TREE_NODE
        from PSTREENODE A,PSTREENODE D where
        D.TREE_NODE=A.parent_node_name AND a.tree_name=D.TREE_NAME AND
      
        A.TREE_NODE='Reocrd-name'

Thursday, 27 March 2014

To  Hide  Page Title tab



 in your component if you have only one page and you want hide tab name so uncheck below check in component level


 then you can use HTML for page Title