Blitz Report Parameter Custom LOV Duplication Validation

Description

Categories
Enginatics
Repository
GitHub
Blitz report parameters using custom LOVs with the same query more than once so that they should be set up as a shared LOV instead

SQL 26 lines

Parameters 1

ParameterTypeList of values SQL
CategoryLOV
xrpv.report_id in (
select
xrca.report_id
from
xxen_report_category_assigns xrca,
xxen_report_categories_v xrcv
where
xrcv.category=:category and
xrcv.category_id=xrca.category_id
)