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:

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):

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:

Thanks