APEX 5.1.4 I have 2 interactive grids on different regions on a page using region display selectors. When users click on a link in the first grid, a function is called which navigates to the region where the second grid is and applies a filter and refreshes the report. Below is my code:
The navigation works fine and the filter applies but am facing 2 challenges:
-
Records appear multiple times when the filter is applied. There is only 1 record that exists but it displays 3 times in the filtered grid until a full page refresh is done then it only appears once as it should.
-
I would like to be able to clear any previously applied filters prior to applying the filter and navigating but all attempts at removing the filter have resulted in errors.
using apex.region("risk_register_ig").widget().interactiveGrid("getActions").invoke("reset-report"); results in an "Error: Ajax call returned server error ORA-01403: no data found for ." error.
I also tried the following code:
var filters = apex.region('risk_register_ig').call("getFilters");
for (var i in filters) {
var filterId = filters[i].id;
apex.region('risk_register_ig').call("deleteFilter", filterId);
}
which results in
Upgrading to a newer version right now is not an option so I am looking for solutions that don't involve upgrading.