Before Query business rules
You can use a Before Query business rule to help support data segregation on an instance. ServiceNow applications that support domain separation may support the separation of data and data routing only, have advanced business logic separation, or support tenant (customer) level administration of the application.
A Before Query business rule is supplementary code that you use to support data segregation within domain-separated environments.
Using the Before Query business rule for data segregation
- When domain separation is not supported by a ServiceNow
application and you must grant or restrict table or row access to one or more
non-internal customers outside of the service provider organization.주:Before you begin developing, contact ServiceNow Customer Support about the application roadmap for that product; domain support improvements may be planned for upcoming releases.
- When a table is domain-separated but access to its rows must be granted or restricted
based on certain conditions that apply only to a set of domains in the system.주:For example, a customer in the X domain has multiple vendors supporting that domain and those vendors are granted access to see only the records that are assigned to them.
Points to consider before creating Before Query business rules
- Where you can, create Before Query business rules at the lowest possible part of the domain hierarchy so that the rule runs only for users that it applies to.
- Know that there are scenarios in the system where business rules may not run or where a user-triggered interaction may not trigger a business rule to run. For example, a business rule won't run when you have transform maps with Run business rules turned off, or you have scripts with the workflow disabled.
- Always populate the condition field to specify when the rule runs. For example, you
can specify if the business rule applies only to certain vendors in a domain. 경고:When designing and coding business rules (especially Query business rules), limit OR clauses and searches in non-indexed fields. Too many OR clauses and searches in non-indexed fields can slow queries or affect how your instance performs.
Use Before Query business rules only when necessary. Too many Before Query rules can affect how your instance performs.
Data Security restricts…. when interacting with
data.When not to use Before Query business rules and ACLs
Be careful when you use Before Query business rules and ACLs to segregate customer data. By using both business rules and ACLs, you create customizations that you then must maintain. Customizations can potentially cause performance issues. Your development teams should create processes to make sure that they don’t break the system.
Domain separation provides both scalability and governance with the current domain path query method (v3), which is a widely supported framework. The ServiceNow Platform and App teams are responsible for maintaining the framework, taking the burden off the customer.
For companies with many customers in many instances, excessive use of Before queries and ACLs may cause the database queries not to perform well.
How domain separation is enabled
You can enable domain separation with a ServiceNow plugin. A product manager, supported by a development team, manages the functionality. Enhancements and fixes for domain separation functionality are included with ServiceNow releases. Instance owners can consult Customer Service and Support resources, such as the Service Portal, at https://support.servicenow.com for assistance with domain separation.