Deleted compensation workbooks are displayed as options in the "Compensation Plan Name" filter, regardless of the dataset selected in the "Datasets" tab
Reproducing the Issue
- Create a new table or detailed report (canvas)
- Select the "Compensation Planning" domain
- Try to filter the "Comp Plan Name" column
- Under "My selection" it is possible to see deleted compensation workbooks regardless of what data set is selected under "Data sets" tab
Please note that this is an expected behavior.
When accessing filter values using "By my selection" on the filters page, all distinct values present in the database for that column will be loaded. As adhoc is a generic framework that is used by all modules (Sub Domain Schemas), the logic in the filters is generic for all modules. Therefore, we do not provide options to restrict data based on a logic that is specific to a particular domain. So there is no way to restrict only valid forms in popup filters.
Deleted, Compensation, workbooks, Compensation Plan, filter, table, report, Detailed Reporting, adhoc, ad hoc, Comp Plan Name , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem