Sometimes there might be an ask to remove unwanted data like for example, hide inactive Catalog Items from showing in your Reporting/List Filters.
Release or Environment
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.
Documentation on before query business rule:
You can obviously have other solutions like using ACL's as well.