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
  • ...umn(
    label: "value1",
    field: "value1",
    data: index(local!arrayData.data, "value1", null)
    ),
    a!gridTextColumn(
    label: "value2",
    field: "value2",
    data: index(local!arrayData.data, "value2", null)
    ),
    a!gridTextColumn(
    label: "a1",
    field: "a1",
    >> data: index(local!arrayData.data, "a1", null)
    )

    },
    value: local!arrayPaging
    )
    )
    )

    It seems to me I should be able to use .notation to access the array values a1 to a3 using a fixed index but this isn't working for me. Is there an alternative?
    Thanks, James
Reply
  • ...umn(
    label: "value1",
    field: "value1",
    data: index(local!arrayData.data, "value1", null)
    ),
    a!gridTextColumn(
    label: "value2",
    field: "value2",
    data: index(local!arrayData.data, "value2", null)
    ),
    a!gridTextColumn(
    label: "a1",
    field: "a1",
    >> data: index(local!arrayData.data, "a1", null)
    )

    },
    value: local!arrayPaging
    )
    )
    )

    It seems to me I should be able to use .notation to access the array values a1 to a3 using a fixed index but this isn't working for me. Is there an alternative?
    Thanks, James
Children
No Data