Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Hi,
I am trying to download the Data Store Entity in to excel.
If I don't give any selection and filter criteria only 5k records are downloading & if I give selection & filter criteria only 1k records are downloading, but I expect more records to be download.
Is there any limitation from Appian to download the records from data store entity, If yes, then how much records?
Thanks,
Kiran
Discussion posts and replies are publicly visible
As far as I know, this function's speciality is that it can export data sets that are quite large, since it has internal functionality to automatically handle paging over large data sets, etc.
Your question is hard for anyone on this end to answer, though, because you mention that your non-filtered export document contains 5,000 rows, but... what's the total size of that table? As far as any of us know, your table might only have 5000 rows to export when unfiltered. What do you get for the TotalCount if you run a!queryEntity on that DSE? How about if you run it with the same filters that are currently giving you 1000 rows?
Hi Mike,
Sorry for confusion.
My DB has approximate 1M records And there are 5 different services for these records & below is the count for each service
150,001 - service1
150,000-service2
200000-service3
350000-service4
150004-service5
I want to download the file based on service. It's working but only 1k records are coming
Also Database has composite key, so how can I publish this data store?
Currently, I am duplicating my CDT from Database and removing the srvc_nm as primary key and publishing data store.
Is it possible to publish a Data store with composite key?
What exactly are you referring to here when you say "service"? There's no such term, at least one that i'm very familiar with, in the pipeline of DB table -> data store -> data store entity.
As usual my main suggestion is just to start with something simple - get a single table exporting, then work from there.
Thanks for helping.
Yes this function can export large data sets and I am able to do that successfully.
can you help me with:Appian Community