loop91 Header logo
Experiments

Data security filters

Kunal Khatri
#servicenow#security#access#ACL

The infernal error

Servicenow has it’s baggage of issue over the years, but none so infuriating and long standing as this one.

Number of rows removed from this list by Security constraints.

Servicenow error If you ever searched this error you would find very few solution(s). Even ServiceNow would simply suggest that you apply a Before Query businesss rule on the table to modify the query sent to DB layer. The Query Business Rule ( QBR ) is functional but it slows down the querying.

The good news is that, starting Yokohama release ServiceNow has introduced a new feature “Security Data Filters”.

Key Aspects of Security Data Filters:

Let’s create a Security Data filter to understand how it works

Problem statement

Solution

Related list for Data Security Filters

New Data security data filter

Table Name - Preselected
Mode - Filter if security attribute condition met
Filter - Assigned to = is (dynamic) Me

Final result for Case list

That’s all folks

← Back to Blog