Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query not run on initial load

Marius2Apr 13 2010 — edited Oct 21 2010
I have an application with several pages. I have made them in the same way, but they act different.

What I have:
One region with a few select lists, and a submit button. The select list has a default value (which is sett identical in all pages in this discussion)
One region with a report, that runs a SQL based on the choices made with the select lists.

My problem is on initial loade, when I haven't made any choices in the select list. The defaults are set as expected. In some of the pages it loads as expected and the report looks nice and in accordance with the default values set in the select list. In some other pages it always starts wit ''No data found' in the report. Even when the select list has the correct defaults, and if I press the submit button the page reloads with the proper report. As far as I can tell I have made the two pages in the same manner.

It also return the expected result the second time you arrive at the page. So if the initial load returned no data found, and you navigate to another page and back again it will show the report with data.

My question is what can prevent the report from getting the proper defaults set and running the query on initial load of the page that is not the case when the page is resubmitted or loaded a second time.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2010
Added on Apr 13 2010
14 comments
1,606 views