Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
4 subscribers
Views
1861 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
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...
OriginalPostID-140244
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