I have Millions of records in a table, I need to show it in a report but Its not loading in interface. How to resolve this?
Discussion posts and replies are publicly visible
What exactly is your report attempting to show? What data is it trying to access it and how is it being queried onto the interface? When you say "not loading", what is happening instead? Can you share some sample code? The description you've provided so far is vague enough that most of us here won't even be able to guess where to start for assisting you troubleshoot/etc.
I am trying to show Millions of Records in a Report. Which are account related data. When I open the report, it is take long time to show the data. Through a query entity data got fetched.
If you're trying to show millions of records all at once, I'm afraid you're going to find it pretty much not possible, in Appian or pretty much any other software (unless something super expensive and super specialized towards showing massive amounts of data all at once).
Yeah I think we still need more information. If you're looking to display a grid with 1M rows...I don't think there's much you would be able to do in Appian (or another tool to do that). However, charts are often a good way to display trends across a large number of records. What information are you hoping to get out of this report?
Being able to access millions of records is different from displaying millions of records. I would suggest taking a step back and finding out what, as an outcome, needs to be delivered to the user. Do they need to be able to see a summary of the data? Do they need to filter it? Sort it? Find a specific subset of the records, or even a single record? Once they've found a record, what do they need to be able to do with it? (a report from which a user cannot take any action - implicit or explicit - is useless!)
© 2021 Appian. All rights reserved.