This discussion is archived
1 Reply Latest reply: Sep 12, 2013 12:20 AM by nvncro RSS

LOV Requery on Submit of page

AndyLou Newbie
Currently Being Moderated

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?

Legend

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