Before Query BRs Do Not Run on Database Views
Today I learned (TIL)...
“Before Query Business rules that are set on one or more of the tables that are a source of the Database View do NOT impact the results of the Database View.”
Source: https://cz.devoteam.com/newsroom/autumn-lets-start-quick-view-database-views/
How did I stumble on this piece of knowledge, you ask? Ashley Snyder, one of ServiceNow’s 2021 Developer MVPs, pointed me to the blog post above via the SNDevs slack community, which you should join, if you haven’t!
Other resources about Before Query Business Rules:
Video: NOWCommunity Live Stream - Behind the Answers - Before query business rules
Query Business Rules: A Definitive Guide - courtesy of Paul Morris, another ServiceNow 2021 Developer MVP
Controlling record access using ‘Before Query’ business rules
P.S. Actually, I learned this last week but it took me a bit of time to put this post together.