4 Replies Latest reply: Aug 15, 2013 11:29 AM by SATim RSS

    Shuttle oddity - Not populating all values

    SATim

      APEX 4.1

      Oracle 11g

       

      I have a form where you select a department, P37_PROD_DEPT_CD, select list

      Always replacing any existing value in session state

      Static Assignment

       

      <code>

      select PROD_DEPT_CD || ' ' || PROD_DEPT_NM d, PROD_DEPT_HIER_CD r

      from PRODUCT_DEPARTMENT

      WHERE PROD_DEPT_CD != '-1'

      order by 1

      </code>

       

      Now select a subdepartment, P37_PROD_SUBDEPT_CD, shuttle

      Always replacing any existing value in session state

      Static Assignment

       

      <code>

      SELECT prod_subdept_hier_cd || ' ' || prod_subdept_nm d, PROD_SUBDEPT_HIER_CD r

      FROM apnew.PRODUCT_SUBDEPARTMENT

      WHERE prod_dept_cd in (select substr(column_value,1,3) FROM TABLE(util.split( :P37_SUBDEPT_CD_HIDDEN, ':')))

      AND PROD_SUBDEPT_CD not in ('888')

      ORDER BY d

      </code>

       

      Where

      P37_SUBDEPT_CD_HIDDEN

      Always replacing any existing value in session state

      Item source = P37_PROD_SUBDEPT_CD

       

      Returns:

      dr
      936-237 OUTDOOR GAMES/TAILGATE936-237
      936-239 LARGE TRAMPOLINES936-239
      936-278 COOLERS936-278
      936-279 GRILLING936-279
      936-281 FURNITURE936-281
      936-287 SHELTERS936-287

       

       

      Now select a class,  P37_PROD_CLASS_CD, shuttle

      Always replacing any existing value in session state

      Static Assignment

       

      <code>

      select PROD_CLASS_HIER_CD ||' '|| PROD_CLASS_NM d, PROD_CLASS_HIER_CD r

      from PRODUCT_CLASS

      WHERE instr(:P37_PROD_SUBDEPT_CD,prod_subdept_hier_cd ) > 0

      order by 1

      </code>

       

      This code returns a class for all values except 936-278 Coolers.

       

      When I run the code in the database using the subdepartment value of 936-278, it returns the following but not in APEX.

       

      dr
      936-278-135 PERSONAL COOLERS <20QTS936-278-135
      936-278-136 TEAM LICENSED COOLERS936-278-136
      936-278-140 FAMILY COOLERS 20QTS+936-278-140
      936-278-145 SOFT SIDE COOLERS936-278-145
      936-278-150 THERMO ELECTRIC COOLERS936-278-150
      936-278-155 ACCESSORIES COOLERS936-278-155
      936-278-160 JUGS936-278-160
      936-278-163 MARINE COOLERS936-278-163

       

      I'm stumped.  There are no filters, I've tried adding trim to the subdepartment return and the where clause in the class selection.  Debug shows no errors.  Firebug shows the correct value in the DOM.

       

      Has anybody see this behavior?  How do I get this one class to populate in the shuttle?

        • 1. Re: Shuttle oddity - Not populating all values
          Hari_639

          Hello,

           

          Have you specified "P37_PROD_SUBDEPT_CD" as "Cascading LOV Parent Item(s)" for "P37_PROD_CLASS_CD" item?

           

          Regards,

          Hari

          • 2. Re: Shuttle oddity - Not populating all values
            SATim

            Thanks Hari.  Good suggestion.  The subdepartment and class are independent though.  When selecting the left subdepartment shuttle, it populates the left class shuttle.  You can selet the subdept and move to right, then highlite another subdept, get the class and select class and move that to the right.  The processing then uses the shuttle right values.  With that said I tried it anyway and still the same behavior.  I did find some javascript in the HTML Form Element Attribs and am working through that to see if that is my culprit.

            • 3. Re: Shuttle oddity - Not populating all values
              Hari_639

              Can you set-up an example @ apex.oracle.com? That will be helpful to understand your requirement and the issue better

               

              Regards,

              Hari

              • 4. Re: Shuttle oddity - Not populating all values
                SATim

                Finally getting a chance to get back to this issue.  It looks like you were right with the cascading LOV.  The Page items to submit was the culprit.  It was set to the wrong item and when I change it to the class cd, it fixed the problem.  It still is weird compared to the other subdepartments.  When you highlight in the left subdept shuttle, the class values appear for everything except my one problem child still.  After updating the LOV, they still do not appear until you move the subdept to the right shuttle.  But at least they appear now.  Thanks.