Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Highlight Tree Node

boffmanJan 8 2025 — edited Jan 10 2025

Hi,

I've a tree like:

select case when connect_by_isleaf = 1 then 0
                       when level = 1 then 1
                       else  -1
      end as status, 
      level,
      ID,
      PARENT_ID,
      NAME,
      case
          when parent_id is not null then 'fa fa-file-sql-o'
       end as icon,
      ID as value,                 
      null as tooltip,
     'f?p=&APP_ID.:30:'||:APP_SESSION||'::::P30_TREE_SELECT:'||ID as link      
 from SCRIPTS
where  id >= 1 --and status = 0
start with parent_id is null
connect by prior id = parent_id

After I click the node, the page loads and the node isn't highlihted anymore. I don't know what I'm doing wrong?

I'm using Apex 24.1.5

cheers,

Bernhard

Comments
Post Details
Added on Jan 8 2025
1 comment
100 views