Tempo Reports Using Records

hi rizviz ,

go through below link,it may help you.. 

https://docs.appian.com/suite/help/17.3/Tempo_Report_Design.html#tempo-report-design-best-practices

thank you kchaitanyam

Im looking for more detailed guidance on building reports by querying MULTIPLE records. I am using queryrecord(), and want to query multiple records.

FOR EXAMPLE:

 =queryrecord(

     cons!SalesRecordType,

I want con!SalesRecordType to query 4 different records.

How can I handle this scenario?

zrizvi , afaik, we can query from only one record by using queryrecord()

ok thank you. is there a best practice to query multiple records for a report?

zrizvi , we can do by calling queryrecord() separately for each record type. Then, can construct a display cdt by combining all the data to make it simple to process for report.

This can work OK for small projects but on large projects I think this will have performance issues. If you want to join multiple tables you should make a view to join these together. Trying to do joins on the front end is much slower.

> is there a best practice to query multiple records for a report?

Definitely make a view as harrisont606 already mentioned. In most use cases you should be able to create a view to join your different tables and then query it easily in a tempo report, and be easily able to incorporate functionalities such as filtering and sorting.

> is there a best practice to query multiple records for a report?

Definitely make a view as harrisont606 already mentioned. In most use cases you should be able to create a view to join your different tables and then query it easily in a tempo report, and be easily able to incorporate functionalities such as filtering and sorting.