Please provides some use case for "Data filtration"

[Community Alums]

I need a list of places/topics in ServiceNow where we can implement the data filtration functionality. 


Thanks in Advance
Utsav

[Community Alums]

Hi @Utsav JAISWAL ,

Use data filtration to control access to tables and records based on subject attributes when performing read queries.

Data filtration is a separate form of access control designed to work along with the existing Access Control rules (ACLs) on your instance. Data filtration denies access to tables and records that do not match subject attributes defined by an administrator. Data filtration is designed to make auditing, reporting, and troubleshooting easier.

This is an optional feature that administrators can activate on their instance.

Data filtration features

Data Filters Use data filters to grant access based on information within a record. Data filters use data in a tables field to determine whether a record is available to your users.

Subject attribute based condition builder Use subject attributes to evaluate user role, group, subject criteria, or IP network address.

Data filtration uses a deny based model Data filtration uses a deny based model to control access to records. With data filtration, your instance denies access to records unless a record meets the criteria defined by data filtration.

Data filtration enforcement Data filtration rules run after the database query for READ operations and are evaluated before ACLs. A record denied by any data filtration rule will not proceed and be evaluated by ACL rules. Data filtration rule enforcement is consistent with that of READ ACLs. Data filtration, like ACLs, works in conjunction with existing Report_view access control list behaviors. See Report_view access control for further details on configuring these report controls. Use Cases : Data Filtration - Practical use case with APIs  https://www.servicenow.com/community/in-other-news/understanding-the-quot-data-filtration-quot-plugi...

[Mark Manders]

What is your use case? What exactly are you looking for? Or are you really asking us to google for you? The first hit you get is exactly what Sandeep just posted. Why do you need a list of places/topics to implement it?

[Community Alums]

Hi @AndersBGS @Mark Manders @Community Alums 

My use case is like..
1) In incident table, there are many records with different assignment groups..
Suppose I am creating a data filtration, that if user is part of Hardware group then only the user can able to see the records whose assignment group is Hardware.
User (with group hardware)----All assignment group incidents+ Hardware assignment group incidents
User(without group hardware)----All assignment group incidents except hardware assignment group incidents

This use case is working perfectly.

Now, I want to add one more condition

2) In the incident record, I have created a custom field--collaborator (list type).
    Now if, in the collaborator field i have added a user (whose role is sn_collaborate, it is a custom role)
   

So, the use case is like..
If the user which is mentioned in Collaborator field is having the role--"sn_collaborator" then irrespective of user is a part of hardware group, the user can able to see the records in which assignment group is "Hardware" and collaborator is Me.

Here, I have created the 2nd data filtration.

But this 2nd data filtration is not working, maybe because in the 1st data filtration, we are hiding the records(whose assignment group is Hardware) , from the non-Hardware group members.

How can I tackle this use case..

Please let me know, if there is any doubt on the use case..
Thanks in Advance!!
Utsav

[AndersBGS]

Hi @Utsav JAISWAL ,

What do you mean? data filtration can be implemented based on table. What is your requirement / use case?

if  my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders