• State Not Answered
  • Replies 4 replies
  • Subscribers 5 subscribers
  • Views 1848 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

190101 - no subject - How to efficiently display data from mul

mjmallet
How to efficiently display data from multiple tables in a report?

I have to create a report that will be retrieving all rows from 4-5 different tables. The client wants to have the ability to extract that report into excel.

Is it best to create a view on the database that would consolidate all tables and then create a data type/data store to get that information to display in my grid?

I want to limit the number of queries to the database. If I fetch the data from each tables in SAIL and store it to a local variable, and then query against those local variable.

Which options would be less effort? And what would be the best practice in this scenario?

OriginalPostID-190101

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 1
    As per you requirement, you want to combine the data from 4-5 tables. The approach for this can be creation of a view or by manipulating the results of multiple expressions as stated by sikhivahans. But this absolutely depends on the amount of data on which you want to operate. As in your case, there are 4-5 tables involved, I would suggest to create a view which will avoid the extra overhead from Appian side. Also if there are any search filters you are adding in this report, its simple to have a query with filters(In case of view) rather than filtering in all different rules(if you are handling in SAIL).
Reply
  • 0
    A Score Level 1
    As per you requirement, you want to combine the data from 4-5 tables. The approach for this can be creation of a view or by manipulating the results of multiple expressions as stated by sikhivahans. But this absolutely depends on the amount of data on which you want to operate. As in your case, there are 4-5 tables involved, I would suggest to create a view which will avoid the extra overhead from Appian side. Also if there are any search filters you are adding in this report, its simple to have a query with filters(In case of view) rather than filtering in all different rules(if you are handling in SAIL).
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.