5 Replies Latest reply: Jul 30, 2013 6:22 AM by ac4991 RSS

    HGrid Entry Page Implementation

    ac4991

      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

          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

            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

              Hi,

               

              Thanks for all your support.

              I've pulled it off now.

               

              Regards

              Ari

              • 4. Re: HGrid Entry Page Implementation
                Swati
                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

                  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