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

vaibhav000 · ‎01-07-2016

Hi,

Please find the Excel sheet screenshot where i am getting 95 records for the same table.

Regards

Vaibhav

Anurag Tripathi · ‎01-07-2016

Very interesting, can you tell me the table on which this is being observed, also the version you are on.

-Anurag

vaibhav000 · ‎01-07-2016

Hi Anurag,

I have observed this in Category Table.

Version: Fuji

Regards

Vaibhav

Anurag Tripathi · ‎01-07-2016

can you provide a screenshot of the list you are seeing where it shows 34 records

-Anurag

vaibhav000 · ‎01-07-2016

Please find the screenshot.

Regards

Vaibhav