Getting different number of records in Service-Now and the Exported Excel for the same table

vaibhav000 · ‎01-07-2016

Hi All,

I have been exporting the data of one of the table into Excel and found that it gave me 95 number of records whereas in the service-now instance it shows only 34 records.

From where these extra records are coming from?

Need Suggestions please.

Regards

Vaibhav

Anurag Tripathi · ‎01-07-2016

It is happening because of query business rule 'Hide admin homepage categories'

If you deactivate that and open the table you will get all 95 records.

The query br is stopping the records from being displayed on the list but for some reason it is not being applied to the export function.

-Anurag

View solution in original post

Anurag Tripathi · ‎01-07-2016

this is the name of the business rule

'Hide admin homepage categories'

-Anurag