140244 - no subject - It seems I can't expose the certain data

robbier over 9 years ago

It seems I can't expose the certain data in a portal report and I'm not sure if it is me or not. So I have an existing tasks portal report which works just fine. I've added a new column to this report and am trying to expose is the some additional data which is buried inside a process variable. This process variable is a CDT. In this report I access other columns of this CDT and no problem. For example in the Data tab of other working columns I do the following:

index(pv!MyCDT,"Field1",-1)

..and the report spits out the data for Field1 with no problems. The wrinkle in my new column seems to be that this particular column I am now trying to expose is a CDT array, that is: MyCDT.CDTFieldList.FieldA, where CDTFieldList is a CDT as an array and FieldA is a single-valued boolean. A little gnarly but not unheard of. Ultimately I want need to check to see if any values of the FieldA are true but I can't even get that far. When I attempt to set up an expression i...

Discussion posts and replies are publicly visible

Parents

0 robbier over 9 years ago

..not what I was hoping for...

I did try your second suggestion-- tostring(index(MyCDT,"CDTFieldList",null))

All of the data in that column in null. I had attempted a similar expression earlier except using count(index(MyCDT,"CDTFieldList",null)) and got the same results..blank.

It really seems to me the portal report can't into a 2nd-level array. What I've done is actually go into the process model and use an expression to bubble up my "FieldA" into its own process variable. I then expose that in the report. Was hoping to keep these things separate but this seems the only way I can do it for the time being.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 robbier over 9 years ago

..not what I was hoping for...

I did try your second suggestion-- tostring(index(MyCDT,"CDTFieldList",null))

All of the data in that column in null. I had attempted a similar expression earlier except using count(index(MyCDT,"CDTFieldList",null)) and got the same results..blank.

It really seems to me the portal report can't into a 2nd-level array. What I've done is actually go into the process model and use an expression to bubble up my "FieldA" into its own process variable. I then expose that in the report. Was hoping to keep these things separate but this seems the only way I can do it for the time being.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data