Export to Excel file does not download exact number of rows displayed in list view. Any suggestion ?

[Amarendra]

Export to Excel file does not download exact number of rows displayed in list view. e.g- i can see all active notification which says- "1 to 300 of 323" on a page when i export it to Excel it downloads only 303 rows. I am using Eureka release.

[Amarendra]

any suggestion on my last comment ? it seems ACL is also impacting Glide query

[Amarendra]

didn't find anything relevant. When i tried to check the same through following script:

var grec=new GlideRecord('sysevent_email_action');

grec.addQuery('active','true');

grec.query();

gs.print(grec.getRowCount());

It also gave me the value 303 which is the same no. of rows i was able to export to excel.

Now my question is can ACL prevent you to count the exact number of rows ? or the list view is showing incorrect no. of rows.

[Inactive_Us1474]

Hi,

The script has returned correct number of rows which is mentioned in the list view because ACL is restricting the read/write view on records of the list.

Thanks.

[Amarendra]

Please see original question. Total no. of rows are 323, i am able to export 303 and same is the value returned by script query. So ACL is affecting "export" and "script query" as well. But how come restricted rows are there in List view, if "Read" restriction is applied?

Any suggestion?

Thanks

[Aric5]

I agree with what other people are trying to say.     Scroll to the last page you have data and look for the following:
Number of rows removed from this list by Security constraints: 20

The number removed will vary depending on how many rows are left on the display page ....and the amount of data left.   The total number of rows will always display in the upper right hand corner though.     So for example if you are showing 100 rows per page on page four you would see the above statement with 23 instead of 20.   If you are showing 20 rows per page on the last 2 pages you would see 20 and 3 consecutively.

This is the only thing I can think of unless you have some sort of weird macro in excel that auto removes duplicates.

Please don't forget to mark helpful and/or answered if either or both.