Summary
Sometimes there might be an ask to remove unwanted data like for example, hide inactive Catalog Items from showing in your Reporting/List Filters.
Instructions
If the data is being displayed through a reference field, check if you can provide the condition through the reference qual condition on the dictionary record. If the condition cannot be achieved through the reference qual condition, then you can write a before query business rule. In this case, you can have a before query business rule on sc_cat_item table.
Related Links
Documentation on before query business rule:
You can have other solutions like using ACLs as well.
