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

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 ...

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 ...