question Re: query business rule is not applied for report export in ServiceNow in Developer forum

query business rule is not applied for report export in ServiceNow

bhaskarnataraju — Wed, 21 Dec 2022 11:54:41 GMT

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

Re: query business rule is not applied for report export in ServiceNow

Raghav Sharma24 — Wed, 21 Dec 2022 11:48:23 GMT

You are trying to say that export is showing more records than list visible to users?

Ideally export only exports the data visible on list.

Re: query business rule is not applied for report export in ServiceNow

bhaskarnataraju — Wed, 21 Dec 2022 11:56:53 GMT

Hi Raghav,

Thanks for your response.

Yes. export shows more records than list visible.

Re: query business rule is not applied for report export in ServiceNow

Raghav Sharma24 — Wed, 21 Dec 2022 12:28:26 GMT

@bhaskarnataraju do you have a domain separated instance?

Re: query business rule is not applied for report export in ServiceNow

reshmapatil — Wed, 21 Dec 2022 12:35:20 GMT

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**

Re: query business rule is not applied for report export in ServiceNow

bhaskarnataraju — Wed, 21 Dec 2022 13:46:39 GMT

Hi Raghav,

Yes. We are working on domain separated shared instance.

Re: query business rule is not applied for report export in ServiceNow

Raghav Sharma24 — Wed, 21 Dec 2022 13:52:00 GMT

@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-separation/concept/bp-before-query-business-rules.html

Please mark the answer correct/helpful accordingly.

Re: query business rule is not applied for report export in ServiceNow

bhaskarnataraju — Thu, 22 Dec 2022 06:48:35 GMT

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

Re: query business rule is not applied for report export in ServiceNow

bhaskarnataraju — Thu, 22 Dec 2022 06:49:24 GMT

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

Re: query business rule is not applied for report export in ServiceNow

Raghav Sharma24 — Thu, 22 Dec 2022 06:55:45 GMT

@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.