1 Reply Latest reply: Sep 12, 2013 2:20 AM by nvncro RSS

    LOV Requery on Submit of page

    AndyLou

      Apex 4.2

      I have a select list that is the child of another select list.

      When the parent select list changes the child select list is updates as expected..great.

       

      The problem is when I submit the page the query that populates the child LOV appears to be executing again , this is not needed. It slows the whole report down.

      Child LOV Source

      Page Action When Changes None(default)

       

      Display Extra Values:NO

      Display Null Values:YES

      Cascading LOV Parent p380_depot

      Optimize Refresh YES

      Default All

       

       

      SELECT d, r  FROM

          (/*+ RULE */

           SELECT DISTINCT

               Tour as d,Tour as r

            FROM high_profile_report

            where del_depot=:P380_DEPOT

          )

        ORDER BY r

       

      Why is this LOV source SQL running again on Submit Page?