This discussion is archived
5 Replies Latest reply: Jul 30, 2013 4:22 AM by ac4991 RSS

HGrid Entry Page Implementation

ac4991 Newbie
Currently Being Moderated

Hi Experts,

 

I'm trying to implement HGrid for an entry page.

 

The concept is:

Firstly in the PR method, data will populate in the HGrid. The data result set will present in two levels of hierarchy.

For E.g:

Hierarchy                --      Qty

---------                --      ---

 

- WV-CT-TR            --      75

--- A15-101-GN1      --      45

------- FG-34          --      10

------- FG-36          --      15

------- FG-38          --      20    

 

--- A15-101-RB1      --      10

------- FG-32          --      5

------- FG-36          --      5

 

--- A15-115-BL1      --      20

------- FG-40          --      20

 

- WV-CP-JK             --      50    

--- A15-132-BG1      --      50

------- FG-50          --      25

------- FG-60          --      25

 

Now, If u closely look into the Qty values for each node then u'll notice that the group nodes are actually carrying the total value of the details.

 

This is what i need to take input from the user. I mean, the user can choose to enter a summarized value in the group nodes (in this case after user enters we'll need to internally distribute the sum value into the child nodes, based on certain rules) or else the user can enter directly in the child nodes (in this case we'll internally sum up the values and initiate the group nodes)

 

Plz help me accomplish this. I dunno how to prepare the BC4J and HGrid design for this particular model.


Regards

Ari

  • 1. Re: HGrid Entry Page Implementation
    ac4991 Newbie
    Currently Being Moderated

    Hi,

     

    I forgot to attach the data results based on which this design has to be prepared.

    Here it is ...

     

    CategorySub CategoryItem
    WV-CT-TRA15-101-GN1FG-34
    WV-CT-TRA15-101-GN1FG-36
    WV-CT-TRA15-101-GN1FG-38
    WV-CT-TRA15-101-RB1FG-32
    WV-CT-TRA15-101-RB1FG-36
    WV-CT-TRA15-115-BL1FG-40
    WV-CP-JKA15-132-BG1FG-50
    WV-CP-JKA15-132-BG1FG-60

     

    We need to transform the above data into the above hierarchical view.

    Regards

    Ari

  • 2. Re: HGrid Entry Page Implementation
    ac4991 Newbie
    Currently Being Moderated

    Hi,

     

    Thanks for the views folks.

    Please share even the smallest of information (it may be of great value).

    Regards

    Ari

  • 3. Re: HGrid Entry Page Implementation
    ac4991 Newbie
    Currently Being Moderated

    Hi,

     

    Thanks for all your support.

    I've pulled it off now.

     

    Regards

    Ari

  • 4. Re: HGrid Entry Page Implementation
    Swati Explorer
    Currently Being Moderated
    Hi Ari,
    Here is one sample Ex:
    Step 1) Created three view objects using following queries:
    XxParentVO
    select 1 parent from dual
    union all
    select 2 parent from dual
    union all
    select 3 parent from dual
    XxChildVO
    select 2 parent, 'A' child from dual
    union all
    select 2 parent, 'B' child from dual
    union all
    select 1 parent, 'C' child from dual
    XxChildOfChild
    select 'A' child, 'AB' childOfchild from dual
    union all
    select 'B' child, 'BA' childOfchild from dual
    union all
    select 'A' child, 'AA' childOfchild from dual
    union all
    select 'A' child, 'AC' childOfchild from dual
    union all
    select 'B' child, 'BB' childOfchild from dual

    Step 2) Create two view Links
    XxParentChildVL
    Source Attribute: XxParentVO --> parent  (attribute selection)
    Destination Attribute: XxChildVO --> parent (attribute selection)
    View Link Properties: Destination View object checked named given to Accessor as XxChildVOAcc
    XxChildsVL
    Source Attribute: XxChildVO --> child (attribute selection)
    Destination Attribute: XxChildOfChildVO --> child (attribute selection)
    View Link Properties: Destination View object checked named given to Accessor as XxChildOfChildAcc

    Step 3) Add into Application Module like
    XxParentVO --> XxChildVO --> XxChildOfChildVO
    Step 4) HGrid Region Creation:
    hgridRN
    --> treeRN
    --> members
    ----> nodedef1 (ViewInstance: XxParentVO and ViewAttribute: Parent)
    ----> childNode1 (ViewLinkAccessor: XxChildVOAcc)
    -------->members
    --------> nodedef2(ViewInstance: XxChildVO and ViewAttribute: Child )
    -------->  childNode2 (ViewLinkAccessor: XxChildOfChildAcc)
    ------------->members
    ---------------> nodedef3(ViewInstance: XxChildOfChild and ViewAttribute: Childofchild)
    Swati
  • 5. Re: HGrid Entry Page Implementation
    ac4991 Newbie
    Currently Being Moderated

    Hi Swati,

     

    I tried exactly the same thing. Which actually worked somewhat, but still a issue was there which was that i was only getting the top node and not the corresponding child nodes.

     

    Which later on started working .. when i did the following:

    I changed the hierarchical level in the AM shuttling. I mean earlier i was shuttling all the VOs in the AM separately,

    then i shuttled the VOs like

    CategoryVO

         -->     SubCategoryVO Via VL

              -->     ItemVO via VL

     

    This is how it started working. I guess u meant the same by the following line in the above post:

    Swati wrote:

    Step 3) Add into Application Module like

    XxParentVO --> XxChildVO --> XxChildOfChildVO

    Thanks a ton Swati, u helped me a lot in this

     

    Regards

    Ari

Legend

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