Support Topics Documentation Slack YouTube Blog

Retrieve related data through Data Table

Hello,

I would like to retrieve related data through a 1:n relation from the Users table and use this in a data table:
image

What do i need to use to load the data in the data table? Can i do this with On Before Mount?
image

Which component can i use to connect the On Before mount and the related data?:

Hello Michel,

A few questions:

  1. At what point should the data get loaded? When the page opens? When the user does something on the screen?
  2. Based on what criteria do you need to load related data? For example, all objects of the currently logged in user?
  3. What is the name of the related data table?

Regards,
Mark

Hi Mark,

1.First table when the page opens. But i also need a solution when the user checks a radio button.
2.I need the data which has a relationship from table Users 1:n to table dossiers.
3.Related table name is users, but i need the data in the table of the table dossiers.

one additional question, is it possible to change the width of the columns within this Data Table?

Hello @Michel_Loriaux

You can do what you want like this:

  1. Add a table using the Date Table component
  2. Add logic On Record Selected in which:
  • select the relation of this entry
  • save to Page/App Data
  • display saved relation objects

You can only change the width of the table