queryProcessAnalytics Output.txt
Hi,
On an interface I am populating a grid based on a datasubset that is from a queryProcessAnalytics (output attached).
I then click a row in the grid to display more details from the process.
In column "c16" I have the entire data set which as you can see is a complex data type. What I would like to do is display all values that are associated with "Account_Number" for example. For this so far I have tried ...
a!textField( label: "Fund List", value: a!forEach( items:local!selectedCorporateAction.c16, expression: keyval({local!selectedCorporateAction.c16},"Account_Number","=",",") ), readOnly: true ),
But it only returns the first one.
Any suggestions as to how to return all related values in to an arrary?
Thanks!
Discussion posts and replies are publicly visible
Hi David -
Regardless of the grid design - I think you should probably be using fn!index() and not fn!keyVal().
There's some nuance here - but please review the docs to see what I meanhttps://docs.appian.com/suite/help/19.3/fnc_text_keyval.htmlhttps://docs.appian.com/suite/help/19.3/fnc_array_index.html
Also, Have a look at the fn!wherecontains docs: https://docs.appian.com/suite/help/19.3/fnc_array_wherecontains.html
In particular this index(..., wherecontains(...)) pattern is probably going to be useful to you:
e.g. index(pv!employees.firstName, wherecontains("Finance", pv!employees.department))