I have a paging grid and in one of the columns the data is from a nested cdt. While I am able to get the data portion I am unable to sort the column. I've tried using parentfield.childfield , using index function. What is the best or most simple way to go about this?
Discussion posts and replies are publicly visible
Create a dictionary from your nested CDT. Each column in the table is represented by an element in the dictionary.
I would create a rule that takes in your nested CDT and then in the rule you have something like the following which returns back a dictionary:
= {
a: ri!myCdt.a,
ab: index(ri!myCdt.a, "b", {})
}
Then in your table you just reference the dictionary.