Hi,
I'm building a master detail page and use the sample application as a starting point (see https://apex.oracle.com/pls/apex/f?p=160186:2) The application uses a link column in the search results to navigate to a specific record:
apex_page.get_url(p_items => 'P2_ID', p_values => "ID") link
When clicking a result, the entire page is refreshed, including the classic report with search results. Consequently the search query gets re-executed every time, which can slow down the application.
=> Would there be a good solution to avoid re-excuting the search query when opening a result?
Additionally, the list_class column is used to indicate which record is currently selected:
case when nvl(:P2_ID,'0') = "ID"
then 'is-active'
else ' '
end list_class
=> Would there be a way to keep this functionality while avoiding to re-execute the query every time?
Many thanks!