Reports

Hi deviratnamv,

I think logically it is possible by pagination,because at a single instance you won't fetch all the 100000 reports so by using pagination you can achieve.By default you can view the first 100 different reports .Lets wait for the other inputs.Choose the best suits to your requirement.

Thanks,
ravalik

Hi Devi,
Can you elobrate, what you mean by 100000 reports in tempo reports?

Did you mean 100000 rows in a report or 100000 different reports under tempo reports?

Hi Ravichandrant,

I want to display more than 100000 records in tempo reports and i have to export data to excel.

Hi deviratnamv,

yes it is possible by using pagination for the grid.

For this, first u can take startIndex=1 and batchSize=100 then for every iteration you have to increase the bacthszie.

After display the data in the grid, you have to used sql to excel plugin fore export the data.

Hope it is helpful .

Thanks,
Bhanu

Hi Devi,

You can display the specified number of reports in tempo but the thing is even if you apppy pagination 100 records in each page for that then it is not recommendable way because how frequently user clicks to see the last page in your case with pagination user has to click next button 100 time. instead it is recommend to use as many as filters to and corner down what user wants to see.

If you still want to go with the pagination as every one suggest you can go with pagination option.

Thanks

You can have a report that has that many rows, but you will want to display in batches in order to (1) not exceed memory limits and (2) provide a positive user experience (no one person can consume that many rows in one view within Appian, as it is not a BI tool).

This link will tell you about different query options (recommended is queryEntity)
docs.appian.com/.../Querying_Data_From_an_RDBMS.html

This link will discuss performance monitoring
docs.appian.com/.../Logging.html

This link will tell you about paging
docs.appian.com/.../fnc_system_a_paginginfo.html

Hope this helps!

As others have said, for a report this large paging is 100% necessary (although you really should always have paging). However paging/sorting will not be sufficient for that number of records. You will need to build multiple search fields which have their results passed into your query entity, otherwise users will never find the records they care about in such a large report. Do not attempt to use filter expressions or wherecontains to find data, let the database do what it is good at.

AFAIK the best option to display these number of rows would be : 

• Use pagination to display records.
• Use different search criteria based on your requirements so that user is able to search required record.
• You can use exportable datasubset to export data in excel but here I would suggest you limit your rows because if data exceeds defined size than it may break.

 

Let me know in case of any queries.

 

Regards,

Trunal Jain

Hi,
You can display the specified number of rows/records in the report using pagination.
Using the attributes startIndex and batchsize you can display 100 records per page using iteration(to display 10000 rows).
However paging/sorting will not be sufficient for that number of records as user has to keep clicking on next until he/she gets the required record. Hence recommended option is to provide multiple search filters based on your requirements.
Thanks.