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