#SAIL Hi there, I'm having trouble to print some data

#SAIL

Hi there,

I'm having trouble to print some data on a Grid.

We are using the following structure on a CDT (which is also a database on MySQL):

CDT1
          CDT2 (multiple)
                    field1
                    field2
                    field3

When I use a rule to filter my CDT1 and find the CDT2 objects which correspond to it,
I cannot print the field1, field2 and field3, because an error appears saying
they're not list type.

I understanded that the grid text column just prints an array, and my array is the
CDT2, not the fields inside of it. I want to know how can I print the fields on the Grid,
putting them inside an array. Is there some way to do this ?

I have a foreign key of my CDT1 inside my CDT2, but it cannot be used with Appian Query Rules.

Here's a practical example of what I'm trying to do:

a!gridTextColumn(
label: "Field1",
data: index(
local!datasubset.data.cdt2,
"cdt2.field1",
{}
),
field: "field1"
)

Thanks !

...

OriginalPostID-99711

OriginalPostID-99711