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 Lakshmi Meyyappan over 9 years ago

If I understand correctly, you don't need the count of how many are true, you only need to know if any of the FieldA values are true? I would suggest you use the or() function. It would look something like this: or(index(index(pv!MyCDT, "CDTFieldList", false), "FieldA", false))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Lakshmi Meyyappan over 9 years ago

If I understand correctly, you don't need the count of how many are true, you only need to know if any of the FieldA values are true? I would suggest you use the or() function. It would look something like this: or(index(index(pv!MyCDT, "CDTFieldList", false), "FieldA", false))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data