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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Highlight Tree Node

boffmanJan 8 2025 — edited 6 days ago

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
49 views