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 EntityItems--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 - a3load( 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
Discussion posts and replies are publicly visible