Hello there!
Here is my use-case: I have a large record type (80'000 rows), which users want to be able to filter and export to Excel. It works pretty good, but my platform admin is kind of obsessed by the health of the platform. He is afraid that many user export the whole set of data at the same time, putting the server CPU into heavy load.
So it is required to limit the number of records a user can export.
Did anyone ever have something similar to do?
I know the limit is set to 100'000, but can we decrease the same in some Appian administration setting?
I see no property in the gridField to do so, e.g. to set "showExportButton" to false if the size of the dataset exceeds a given value. Is there any?
I think it would be possible to obtain something with something like a readOnlyGrid or so, but I would like to avoid it for the pain of handling filters (and pagination?). Please help!
Discussion posts and replies are publicly visible
Did you consider to disable export in general, but create a excel file once every night and let users download it?
Yes, but my platform manager will also chalenge the big CPU usage at night. And I would need to let the user filter the data before export which would require a specific configuration interface for the export. However it stays the best workaround so far.
What is this export used for?
I have seen clients talking Excel export all day long, but once reconsidering what people are doing with it, it was way easier to let people do it directly in Appian. In the end, quite some of these "technical" challenges find a simple solution on the business side.
Of course. But it is a good way to have a "slow" platform, and good idea to sell consultant advice, it would seem. And we have the very data I try to access *displayed on the very page* (in the pagination info - [1-15 of 86,153 > >>]).
Just saying.