How to use a!queryentity to query data from multiple CDTs?

I am using three a!queryentities inside {} curly braces to query data from 3 CDT's. Data is getting populated in the rule but problem is in the grid. In grid data is getting populated for the first two columns but not for the other columns as they contain multiple data. Code used :

local!datasubset:todatasubset(local!data),
a!gridTextColumn(
                            label: "Mach 5 CCD",
                            field: "CUST_CMMT_DT",
                            data: index(
                              local!datasubset.data,
                              1,
                              "CUST_CMMT_DT",
                              null
                            )
                          ),
 identifiers: index(
                          local!datasubset.data,
                          1,
                          "FTN_NBR",
                          {}
                        ),

 

If I remove 1 from grid text coloumn then data is getting populated but in random order. Thanks in advance.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data