Understanding report grids and extended use-cases

[mcleo-d]

The following question was raised by @nitin-bhagwat from NatWest Group below ...
#7098 (comment)

Question

Hi Team
We would like to have better understanding on report grids and its extended use-cases. Few queries are listed below:

• How to add more subjects in reporting grid feature?
• How can more data entity can be added into subjects in reporting grid?

[davidwatkins73]

The report grid can render cells based on a fixed set of relationships it understands. For example, it can render any assessment rating value as the link from an app to an assessment is fairly simple to traverse (Assessment Def, Application, Assessment Rating, Rating Scheme Item). Similarly it supports all the base relationships seen in this screenshot:

To increase the coverage of these types would require changes to the report grid implementation code: org.finos.waltz.data.report_grid.ReportGridDao. This code basically looks at all the column definitions and groups them by their type (survey questions, involvement, assessments etc) and then constructs makes some bulk queries to fetch the data and rejoin tem (see the methods prefixed with fetch).