APEX: Submit without refreshing the page

user_120888 0
Viewed 3727

I have an interactive report that runs a large query, which takes about 20 seconds to execute.

There are many filter items on the APEX page, which affect the data in the report.
The report uses a PL/SQL query, which references the items on the page, to pull the data.

Since most users need to set multiple filters before submitting, I created a Run Report button which submits and refreshes the page, so users don't have to wait 20 seconds multiple times while they set multiple filters.

The problem is, some of the filters are select lists.
And these select lists are populated based on PL/SQL queries, which pull data from the database, and also reference values in other items on the APEX page as part of the queries.

So when the user selects an item in one of the select lists, I need to submit the item that was "changed" and then refresh the other filter items on the page, but WITHOUT refreshing the whole page/report.

Ajax should be able to do this, right?
How do you accomplish this?

I currently have dynamic actions that refresh individual items, and this seems to be working.
But it doesn't pull the correct data from the database to populate the select lists, because it doesn't submit the other filter items first.

oracle-apex plsql oracle sql ajax
2 Answers

So when the user selects an item in one of the select lists, I need to submit the item that was "changed" and then refresh the other filter items on the page, but WITHOUT refreshing the whole page/report.

That should be fairly simple as Select List items, under the "List of values" group of properties, contain Cascade LOV Parent item(s) property. It is used for the purpose you described.

For example, if there were select list items P1_CONTINENT, P1_COUNTRY, P1_CITY, then - when you select a continent, list of countries displays only countries on previously selected continent. You'd then put P1_CONTINENT into P1_COUNTRY list item's "Cascading LOV Parent item(s)" and that's all.

user_90979060

A lot of a APEX page uses AJAX to refresh parts of the page. So it's there already :) Anyway, for select lists you can use the "Cascading LOV Parent Item(s)" in order to let that select lists refresh whenever other items change their values. For other item which does not have the "Cascading LOV Parent Item(s)", you need to submit the values to the session, before you can use them in some sql. You can create a dynamic action on the items that changes value, do a pl/sql expression just as a dummy

null;

and submit the items value to the session and then do a refresh of the items that needs to be refreshed...

Hope it helps :) and happy APEXing

user_72039980
Related