I want to fetch multiple values and put it in the grid of my tempo report

Assign the child cdt to a local variable and use this local variable to access the component values in a grid. Dot notations in case of 1-M relationships will not work since the index will not be approachable.

Hi Simranjits,

I've assigned the child CDT to a local variable as you suggest, but still didn't work..
Here my script, is there any wrong with my script?

'type!{www.appian.com/.../2009}GridTextColumn'(
data: with(local!temp : local!datasubset.data.position, local!temp.position),
label: "Interest Position",
field: "position"
),

And here is the error message :
Could not display interface. Please check definition and inputs.
Interface Definition: Expression evaluation error at function a!gridField [line 51]: Cannot slice index (index by name on a list) when the element has no list type

Try using this:

with(
local!temp: local!datasubset.data.position,
a!gridField(
.....................
.....................
a!GridTextColumn(
data: local!temp.position))

Hi Simranjits,
I've tried it, and still didn't work.

The error message same like before :

Could not display interface. Please check definition and inputs.
Interface Definition: Expression evaluation error at function a!gridField [line 53]: Cannot slice index (index by name on a list) when the element has no list type

Try using "local!temp.data.position"....

Use index 1 when accessing a list of lists. So local!datasubset.data[1].position

Hi jeaniferg,

Try following way: you need to mention the index of element
= {
load(
local!positionData: rule!sample_PositionData(), /* Query/Expression rule that can return your results set for Grid */
local!gridSelection: a!gridSelection(
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 25,
sort: a!sortInfo(
field: "position", /* Any field for sorting */
ascending: true
)
)
),
          with(
/* Replace the value of local!datasubset with a!queryEntity(), or queryrecord(),
* or use your own CDT array in todatasubset() */
                    local!datasubset: todatasubset(local!positionData, local!gridSelection.pagingInfo),
                    a!gridField(
                              columns: {
                                        a!gridTextColumn(
                                                  label: "Position",
                                                  field: "position",
                                                  data: index(local!datasubset.data, "position", {})
                                                  )
                                        }
                              )
                    )
          )
}

Hi All,

First, thanks for the help. But I think you misunderstand with my problem.
What I mean is, I have one CDT (Evo_jobFair) which has one child CDT (Evo_jobPosition) and they are one to many relationship. Now I want to fetch the field of child CDT and put it on the grid.
For example :
Evo_jobFairCDT - [ParentCDT]
-- idJobFair
-- firstName
-- lastName
-- position (Evo_jobPositionCDT) - [childCDT]
--- idDetail
--- position ---> I want to fetch this field

I've tried using simranjits' suggestion, but still didn't work. Is there any way to fetch that field? Thanks.

I have always fetched child cdt values using that method only. Can you please share the entire expression as an attachment?

Hi simrajits,

Here I attached my script. Please help. Thank you

My Scripts