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
9 replies
Subscribers
10 subscribers
Views
7447 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Unable to fetch entire data using #getdatasubsetdownloadlinkfromprocess
pradeepd761
over 7 years ago
Hi All,
As we have our environment on cloud I am using #getdatasubsetdownloadlinkfromprocess to fetch data from process model.
I am to extract data in excel sheet, however data in table is 7000 rows, but I can see only 1200 being extracted. I have used query entity with pagination(1 to -1).
So, my question is, how do I pull all data (7000 rows), in single sheet of excel sheet without making any changes in configuration file and in single instance.
OriginalPostID-256036
Discussion posts and replies are publicly visible
Top Replies
Gajapathy Ganesan
over 4 years ago
in reply to
Thenmozhi Mohanakrishnan
+1
Thanks Thenmozhi Mohanakrishnan I was also facing this issue and this solution worked!!
Parents
0
sikhivahans
over 7 years ago
@pradeepd May I please know if you are aware of the fact that the 'Download Databsubset' implementation should finish in 60 seconds?
Also, may I please know why the query isn't being expected to run in batches? Afaik querying the huge datasets in a single shot isn't a great way to do things at least when we are in the process. This is because of various reasons such as preventing query rule from failing because of huge datasets, preventing an operation from engaging continuously for large durations and performance issues.
At a high level, I opine that 'Download Datasubset' isn't a right choice for your use case and especially this plugin isn't good when the data sets to export are large.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 7 years ago
@pradeepd May I please know if you are aware of the fact that the 'Download Databsubset' implementation should finish in 60 seconds?
Also, may I please know why the query isn't being expected to run in batches? Afaik querying the huge datasets in a single shot isn't a great way to do things at least when we are in the process. This is because of various reasons such as preventing query rule from failing because of huge datasets, preventing an operation from engaging continuously for large durations and performance issues.
At a high level, I opine that 'Download Datasubset' isn't a right choice for your use case and especially this plugin isn't good when the data sets to export are large.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data