query business rule is not applied for report export in ServiceNow

[bhaskarnataraju]

Hi All,

Before Query business rule is created to restrict users from specific groups which is working as expected. But now we have noticed that same restriction is not applicable when we are exporting report from list(it include restricted groups). Kindly help me to understand why BR is not applied for Export and if any way to handle this.

Thanks & Regards,

Bhaskar Nataraju

[RaghavSh]

@bhaskarnataraju I think that is the issue, the query BR should be at the lowest possible domain,

refer : https://docs.servicenow.com/bundle/quebec-platform-administration/page/administer/company-and-domain... 

Please mark the answer correct/helpful accordingly.

[bhaskarnataraju]

Thanks for Help Raghav. Even after creating BR on lower domain, behavior is still same. We used ACL and its working as expected.

[RaghavSh]

@bhaskarnataraju Glad that your issue is fixed, but that is not how service-now works, with query BR also it should allow you to export only the visible records. You can try that in your PDI which is non domain separated instance.

If in future you face the same problem, try raising a HI ticket with service-now and they can guide you how it should work in domain separated instance and where should you write your query BR.

[reshmapatil · Accepted solution]

Hi @bhaskarnataraju ,

Query Business is used to query records/lists of records when the list/forms load.

It doesn't restrict querying records for other sources like reports, integrations, etc.

The filter added to records checks the database and returns data.

Best to use ACLs to restrict data from everywhere.

Regards,

Reshma

**Please mark my answer correct or helpful based on the impact**

[bhaskarnataraju]

Thanks Reshma. ACL works for both list as well as reports.