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

jeaniferg over 10 years ago

Hi All,

I have one CDT which one of the fields is multiple values. Now I want to fetch that multiple values and put at the grid in my tempo report.
Please tell me how to do it. Because I've tried everyway, but still can't get the solution.

Here I attached my CDT..
Thanks

...

Discussion posts and replies are publicly visible

Parents

0 tharshulas over 10 years ago

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", {})
                                                  )
                                        }
                              )
                    )
          )
}
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 tharshulas over 10 years ago

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", {})
                                                  )
                                        }
                              )
                    )
          )
}
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data