• State Not Answered
  • Replies 7 replies
  • Subscribers 4 subscribers
  • Views 1968 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

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

robbier
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...

OriginalPostID-140244

  Discussion posts and replies are publicly visible

Parents
  • 0
    ...n the Data field like this:

    count(index(pv!MyCDT,"CDTFieldList",-1))
    --remembering that CDTFieldList is a CDT array

    I get a value of 1 in every case (which I know not to be true). When I embed a similar expression (as above) into a debug section on the task form and open that form I get a true count back.

    Really my question is whether or not I can get to the data I need from a portal report? If so then what might I be doing wrong here?

    Hope my explanation makes sense.
Reply
  • 0
    ...n the Data field like this:

    count(index(pv!MyCDT,"CDTFieldList",-1))
    --remembering that CDTFieldList is a CDT array

    I get a value of 1 in every case (which I know not to be true). When I embed a similar expression (as above) into a debug section on the task form and open that form I get a true count back.

    Really my question is whether or not I can get to the data I need from a portal report? If so then what might I be doing wrong here?

    Hope my explanation makes sense.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.