Skip to Main Content

Java Development Tools

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!

adf tree table references foreign key in the same table

AshManukyanJul 7 2015 — edited Jul 7 2015

Hi,

I have this table with parent id referencing the primary key of the same table:

CREATE TABLE KRI_SVN_DIRS

(

DIR_ID NUMBER(15),

PARENT_DIR_ID NUMBER(15),

NAME VARCHAR2(80 BYTE),

AUTHOR VARCHAR2(80 BYTE),

COMMENTS VARCHAR2(500 BYTE)

)

ALTER TABLE KRI_SVN_DIRS ADD (

CONSTRAINT PK_KRI_SVN_DIRS

PRIMARY KEY

(DIR_ID);

ALTER TABLE KRI_SVN_DIRS ADD (

CONSTRAINT FK_KRI_SVN_DIRS

FOREIGN KEY (PARENT_DIR_ID)

REFERENCES KRI_SVN_DIRS (DIR_ID)

ON DELETE CASCADE);

I want to create a ADF tree and relate any selection in the tree with an iterator, and set the selected row as current for that iterator.

This is because I don't know how many levels this table is going to have:

This is my binging:

Captura0.JPG

and this is what I can see in my tree impl with the the natural 2 level view link (created automatically with Business components from tables):

Captura.JPG

So far I can see all levels of my tree but selecting values in it, the iterators are showing second level only.

I just don't want to add view links and create let us say 8 levels of the same view and restrict it to 8 levels only.

I need some code to make it dynamic.

this is my AM:

Captura3.JPG

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2015
Added on Jul 7 2015
3 comments
221 views