This discussion is archived
4 Replies Latest reply: Feb 13, 2012 2:37 AM by 913879 RSS

Multi-level linking between VOs

913879 Newbie
Currently Being Moderated
I am a ADF-Jdeveloper newbie. I am trying to develop a shopping cart based on the following tables.
I have 4 tables-
ItemTable which contains the name and the category to which an item belongs,
categoryAttributes which consists of the attributes which are valid for a particular item category(attribute id) ,
itemAttributes which consists of the following- Item id-i.e. the id of item, attribute id-which is taken from categoryAttributes, attribute value-which has to be filled by the user. And
Lookupvalue table which has the lookup value id and lookup values.

The lookupvalue id is attribute id.

I need to create a UI where the itemAttr table is shown
In this table,I need to show the item id-which should be taken from the item table,
attribute id-has to be taken from the categoryAttributes table only since it contains the ids specific to the category.The values for these ids have to
be displayed from the lookup value table.

I have created a parent child relationship between Item and Category Attributes & Category Attributes and Item attributes.
If i drag the child of category attributes,only category specific attributes are displayed. and if i drag the child of Item,only item id is copied.
How can I implement this 3 table linking where both item id and attribute id can be taken from the parent and the grandparent?

Any help will be highly appreciated.

Thanks and Regards,
Chaya Bhandari
  • 1. Re: Multi-level linking between VOs
    Subramanian Meyyappan Expert
    Currently Being Moderated
    am not sure am understood your post fully.

    here an example goes:
    table1 
     id
    desc1
    
    --------
    
    table2
    id
    desc2
    
    --------
    
    table3
    id
    desc3
    first create association between table1 - id - table2 - id and make table2 - id - table 3- id

    go to the association give right click on the association. and choose viewlink. and in that created viewlink1

    match table1-assoc - table2-assoc and create view link 2 match table2-assoc - table3-assoc. those things.

    and atlast based on the viewlink datacontrol are exposed.

    drag and drop to the new ly created datacontrol as you want.



    sorry for late editing
  • 2. Re: Multi-level linking between VOs
    913879 Newbie
    Currently Being Moderated
    I tried this way but it doesnt seem to work. The value is being passed from immediate parent. However, the child is not able to get the value from the parent of parent.
  • 3. Re: Multi-level linking between VOs
    Subramanian Meyyappan Expert
    Currently Being Moderated
    sometimes i h'd this problem.

    atlast where i did my mistake. there is no matching records

    bychance it happens for you also

    eg:
      employeeid  employeedesc
            
            100        xyz
           
              deptid empid deptdesc
                 
               5000     101     ccc
    
                   managerid, mangerdesc     
            
                        999          LLL
    no matching peform with one another . so it may happens


    if like this means
      employeeid  employeedesc
            
            100        xyz
           
              deptid empid deptdesc
                 
               5000     100     ccc
    
                   managerid, mangerdesc     
            
                       100          LLL
    you can get the mutilevel
  • 4. Re: Multi-level linking between VOs
    913879 Newbie
    Currently Being Moderated
    Thanks for your replies. It works.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points