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.

apex5, null value in tree title makes developer toolbar disappear

PaavoJun 17 2015 — edited Jun 20 2015

Hi

With e.g. tree query:

select case when connect_by_isleaf = 1 then 0

            when level = 1             then 1

            else                           -1

       end as status,

       level,

       (CASE WHEN "ENAME" = 'KING' THEN null ELSE "ENAME" END) as title, -- null value is evil

       null as icon,

       "EMPNO" as value,

       null as tooltip,

       null as link

from "#OWNER#"."EMP"

start with "MGR" is null

connect by prior "EMPNO" = "MGR"

order siblings by "ENAME"

The developer toolbar disappears when there is null value in the Title. This is very very hard to detect problem.

https://apex.oracle.com

workspace: imagetest_ws

user: guru

pass: meditation

app: imgtst

page: 12

Rgrds Paavo

This post has been answered by John Snyders-Oracle on Jun 17 2015
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 18 2015
Added on Jun 17 2015
2 comments
509 views