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

Thanks to both for your responses. So I was thinking that and trying but thought I was getting tripped up over the syntax.

Anyhow, tried using or(index(index(pv!MyCDT, "CDTFieldList", false), "FieldA", false)) in this case and got a similar result of "false" when I know (and can see manually in the process data) that there are a bunch of true values.

It really seems to me the portal report is not able to "dig" into an embedded array within a process variable--at least not a CDT-based array.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 robbier over 9 years ago

Thanks to both for your responses. So I was thinking that and trying but thought I was getting tripped up over the syntax.

Anyhow, tried using or(index(index(pv!MyCDT, "CDTFieldList", false), "FieldA", false)) in this case and got a similar result of "false" when I know (and can see manually in the process data) that there are a bunch of true values.

It really seems to me the portal report is not able to "dig" into an embedded array within a process variable--at least not a CDT-based array.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data