First try was looking at the saved reports view in the application builder, but that didn't help.
And again the APEX Dictionary Views to the rescue.
Following query can be used to check if a column is used in a column filter or highlight.
SELECT r.created_by
, condition_type
, cond.condition_name
, condition_column_name
, cond.condition_operator
, cond.condition_expression
, cond.condition_expression2
, cond.condition_display
FROM apex_application_page_ir_cond cond JOIN
apex_application_page_ir_rpt r
ON r.application_id = cond.application_id
AND r.page_id = cond.page_id
AND r.report_id = cond.report_id
WHERE cond.application_id = :application_id
AND cond.page_id = :page_id
AND cond.condition_column_name = :column_name
;
Note: It will not find column usage in a row filter.
May the APEX Dictionary be with you!
No comments:
Post a Comment