Skip to Main Content
Forums

SQL & PL/SQL

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.

facing issue with clause after 19c upgrade

Nishant RanjanFeb 17 2022 — edited Feb 17 2022

i am facing issue with below SQL .Into v_chr_sernumdata is causing issue

WITH t
AS (SELECT v_chr_sernum
AS in_cls
INTO v_chr_sernumdata
FROM DUAL),
t1
AS ( SELECT DISTINCT
REGEXP_SUBSTR (
in_cls,
'[^,]+',
1,
ROWNUM)
names
FROM t
CONNECT BY ROWNUM <=
LENGTH (
REGEXP_REPLACE (
in_cls,
'[^,]'))
+ 1)
SELECT RTRIM (
XMLAGG (
XMLELEMENT (
a,
names
|| ',').EXTRACT (
'//text()')),
',')
v_chr_sernumdata
FROM t1;

Comments

fac586

Please update your forum profile with a recognisable username instead of "User_GP1QN".
Always state your full APEX version number when posting a question.
I created a list with parent and child entries.
How?
I have the list on a page, in a Tab Container. The Appearance.Template is set to Standard.
Which template?
The child entries do not appear in the list; only the parent entries appear.
What is the list template?
How do I get the child entries to appear?
Depends on why they are not appearing. Maybe the list hierarchy isn't properly configured. Or the list template doesn't have support for hierarchical lists. Give us the complete picture.

mt

I've updated my forum profile.
I am using Apex Version...20.2.0.00.20. Universal Theme
I created a list via: Shared Components-> Navigation - Lists
the list is being used in a region (Region type = Static, Region Appearance Template = Tabs)
The Attributes of the list are set to: List -> Attribute -> Appearance -> Links List
The list template is Links List (Theme = Universal , class = Vertical Unordered List without bullets)

fac586

Using the Links List template, sublists are only shown when the parent item is current for the page. This is controlled using the Current List Entry settings for a static list entry or the [is_current] column position in dynamic list queries.
Otherwise they can be displayed by applying the is-expanded class to the parent element in User Defined Attribute 3 (A03) in static lists/the [attribute3] column in dynamic lists, or adding it using dynamic actions.

1 person found this helpful
mt

thank you

I have a possibly related problem. I am running Product Build 211.4, Patch Version 4. I built an application about 3 years ago on this server under a previous version. I hadn't used it in quite a while but when I did so a few days ago, all of the child tabs are missing. In the Desktop Navigation Menu I have numerous entries and many of them have a Parent - see attached.
apex tabs.png (125.99 KB)None of those appear. Something appears to have happened as a result of an update to the APEX version. I apologize for not religiously reading the notes when a new release is deployed.
Bill

fac586

Not related. The Navigation Menu does not use the Links List template.
Create a new thread with a clear description of the problem.

Thank you.
Bill

User_EJSCN

We need to select "Tree List" as List Template in Attributes tab.
Parent-Child-List-Attibute-Settings.PNG (36.81 KB)

1 - 8

Post Details

Added on Feb 17 2022
3 comments
346 views
1 mention