How to get hold of the data in the nested array?

I am trying to build a report in Tempo but I am getting stuck on how to get hold of the data in the nested array. Here is an example of what I am working with along with the report I have built so far. Should I restructure my CDT or is it possible to get the results I want?

CDT defined Data Store Entity
Items--value1
value2
           array--a1 (Milestone Name - start, middle, end)
           a2 (Boolean status - true, null, null)
                     a3 (Datetime Stamp - datetime, datetime, datetime)
                              
Display in SAIL report as:
value1 - value2 - a1 - a2 - a3

load(
local!arrayPaging: a!pagingInfo(
startIndex: 1,
batchSize: 20
),
with(
local!arrayData:
todatasubset(
rule!FetchArray(
ri!matchingid
),
local!arrayPaging)
,
a!gridField(
label: "Display in SAIL report",
totalCount: local!arrayData.totalcount,
columns: {
a!gridTextCol...

OriginalPostID-168593

OriginalPostID-168593

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data