Idea Summary
An OPEN_QUERY_CONTEXT function that works with item-based components - particularly Lists of Values (LOV) - in a manner analogous to the existing APEX_REGION.OPEN_QUERY_CONTEXT function available for regions.
Use Case
While the original motivation and specific use cases behind APEX_REGION.OPEN_QUERY_CONTEXT are not publicly documented - no corresponding IDEA submission appears to exist - the functionality itself proves valuable for programmatic query access. Whatever those original use cases may have been, they would apply equally to dynamic item-based components such as LOVs.
LOVs have supported multiple columns for several years and, when displayed to users, visually resemble standard reports (classic or interactive reports). Functionally, they behave as dynamic regions that appear upon user interaction and disappear after selection.
One practical application would be implementing application-level logging for LOV result sets respecting search criteria entered by users. Given that a previous proposal for performant and consistent cross-component logging https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-4699 is unlikely to be implemented in the foreseeable future, this enhancement would provide a way to extend Application Logging to LOVs and potentially other query-driven item components as well.