I found this wonderful query to find out all the filters applied to an interactive report
SELECT ircond.condition_name, ircond.condition_type, ircol.report_label,
ircond.condition_column_name, ircond.condition_operator,
ircond.condition_expr_type, ircond.condition_expression,
ircond.condition_expression2, ircond.condition_sql,
ircond.condition_display, ircond.condition_enabled
FROM apex_application_page_ir ir
JOIN apex_application_page_ir_rpt irr
ON ir.interactive_report_id = irr.interactive_report_id
JOIN apex_application_page_ir_cond ircond
ON irr.report_id = ircond.report_id
JOIN apex_application_page_ir_col ircol
ON ir.interactive_report_id = ircol.interactive_report_id
AND ircond.condition_column_name = ircol.column_alias
WHERE ir.application_id = TO_NUMBER (:app_id)
AND ir.page_id = TO_NUMBER (:app_page_id)
AND ir.region_name = 'Interactive Report'
AND ircond.condition_type = 'Filter'
AND irr.session_id = :app_session
AND irr.base_report_id =
(SELECT apex_ir.get_last_viewed_report_id (TO_NUMBER (:app_page_id),
ir.region_id)
FROM DUAL)
BUT... i need to do the same thing for an interactive grid.
I looked thru the tables but could not find something similar to apex_application_page_ir tables for interactive grid.
Can anyone help me find the filters defined in my interactive grid so I can pass this information onto my stored procedure?
Thank you,
Robin