gridField with 2 joined entities query

Hi Elia,

My recommendation would be to create a view in your database that combines the relevant data from the two entities. You can then query this view to pull the data for your grid field.

Thanks,
Lucas

Hi Elia,

My recommendation would be to create a view in your database that combines the relevant data from the two entities. You can then query this view to pull the data for your grid field.

Thanks,
Lucas

I have found this solution

a!gridTextColumn(
label: "Type",
field: "SubprojectType",
data: apply( fn!index ,
apply(
rule!getDecoSpecByFlowID,
index(
local!datasubset.data,
"ID",
null
) ), "SubprojectType",null)
)

I get data of the second table ID by ID of the first table
Then apply filter on the field of the secon table ...
I don't know if this is a good solution because , I think, I get do a DB query on all fields each time I print a single Column ...