0

I would like to populate a Vaadin Grid that gets data from different SQL tables and represent them all in a single grid in a matrix-like structure.

excel like table

For example, the second row gets data from the Monitoring table, the third row gets data from the deployment table, and so on. Similarly, the Consultant column gets data from the consultant table, and Region 1,2 and 3 columns get data from different region tables.

Is there an efficient Vaadin-way to achieve this? Thank you.

So far I am able to populate my grid with a single DTO source.

grid.addColumn(RegionData::getRegion).setHeader("Region 1");
grid.addColumn(RegionData::getRegion).setHeader("Region 2");
grid.addColumn(RegionData::getRegion).setHeader("Region 3");

How can I add Areas and Consultant columns in the same grid?

avocadoLambda
  • 1,332
  • 7
  • 16
  • 33
Anshaz
  • 21
  • 6

1 Answers1

3

TL;DR: you have to do it yourself.

The Grid can only show you a row output for a row of input - so it's your job to join your data into this row.

Join the tables in the DB, which is usually the most efficient; if you have to merge different sources, make sure to cache or batch to avoid the "n+1" problem.

If you also have dynamic columns, you can store a row in a Map. SO has several examples (like Create "rotated" non-buffered grid (Vaadin) or Vaadin - adding columns to grid from map) to show you how.

cfrick
  • 35,203
  • 6
  • 56
  • 68
  • Indeed - there is nothing Vaadin-specific about that, and the most efficient way to join data from different database tables is to use the features provided by your database system (in the case of SQL, that would be JOIN) or the ORM system you may or may not have between the database and your code. – Rolf Dec 07 '22 at 09:10