Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
5 subscribers
Views
3450 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Export to Excel Funcitionality
preetamb
A Score Level 1
over 8 years ago
Our system is hosted on Appian 16.2
We have a requirement to implement a report that would fetch and display ~30000 records from the database.
The source data set will have total 40 fields and user can select reporting fields to display in the grid using a checkbox.
They would also like to have the ability to export this data to excel.
Since user controls what fields to export, we were planning to use the Download Data Subset plugin.
Would it be feasible to download a large data subset(40 fields X 30000 records) using this plugin? Could we land into performance issues?
If yes, can any of you suggest a workaround to implement the export to excel functionality considering that a static base template cannot be used, as user controls what fields to export in the excel?
OriginalPostID-235787
Discussion posts and replies are publicly visible
Parents
0
Chris
over 8 years ago
Using the Download Data Subset plugin you may run into the 1 MB data cap on query results, when trying to grab all records at once. You might want to think about batching, loop over the query rule / queryEntity in batches then combine data subsets.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Chris
over 8 years ago
Using the Download Data Subset plugin you may run into the 1 MB data cap on query results, when trying to grab all records at once. You might want to think about batching, loop over the query rule / queryEntity in batches then combine data subsets.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data