Hi,
I am trying to create a database view between 2 tables one under custom scoped app and a platform table in global scope. I am trying to apply filter condition and it looks like database views have limitation on where clause as per this article (https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0719186). and I tried to create Before Query business rule and now the before query business rules don't run on Database views (Before Query BRs Do Not Run on Database Views — WomenNow).
Does anyone have any recommendation on how to apply where conditions/filters on the columns in the two tables if I want to filter on choice list , date columns and etc?
