Why exporting to Excel is limited to 100 results?

[maxr_]

Why exporting to Excel is limited to 100 results in the export option? Is there a way to increase this limit?

[Wojciech_Sulejm · Accepted solution]

The Excel export is limited to 100 entries because Nuxeo uses a default max page size of that size.

This value can be changed by modifying the nuxeo property called:

nuxeo.pageprovider.default-max-page-size

which can be set to a value that is more appropriate for you, e.g.

nuxeo.pageprovider.default-max-page-size=150

You can simply add that line (with an appropriate value) to your nuxeo.conf file (this file is often located in <NUXEO_HOME>/bin directory, but you can also look it up in your Nuxeo Control Panel).

See: Nuxeo configuration parameters

Please note that a larger value will affect the system performance, but that depends also on usage patterns in your system as well as number of records that is returned by specific queries generated from your requests).

[patrek]

Page size is good when we have paging, like through the web interface, but is problematic when you want to export the data.

[maxr_]

This is a strange behavior for exporting. When we export something, we don't want a sample of it, we want everything. Is there a way to export everything?

[Anahide_Tchertc]

setting 0 as value, see http