We are trying to create a process report containing a column which identifies all instances where the logged in user is a part of a multi valued pv of that instance.

nikhilh0001 over 12 years ago

Hi everyone,
We are trying to create a process report containing a column which identifies all instances where the logged in user is a part of a multi valued pv of that instance.
For this, we created a column with the expression: =contains(pv!myUserArray,loggedInUser()). The PV myUserArray is of User or Group type. Hence we tried converting both the data types to user. We also tried converting both the data types to string. However, the expression either returns False or True for all the rows of the report, even for those where logged in user is not a part of the multivalued PV of that instance.
Can someone please suggest an approach for this ? Thanks!...

Discussion posts and replies are publicly visible

0 anithar888 over 12 years ago

The parameters passed into the contains() function does not match with the return type of the function.
Hence,it might not give the right result.
You can evaluate this expression within your process. That is,use the getdistinctusers() function to get the variuos users in the userOrgroup PV and then on the report apply the contains() function on this result with the loggedInUser() function.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 elizabeth.epstein over 12 years ago

Unfortunately you won't be able to use getdistinctusers (or any other appian scripting functions) in a report. I think you are on the right track. Try wrapping loggedinuser() in topeople() to convert it to a type that matches your user or group array.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aweiman over 10 years ago

I had a similar problem with Contains in a report - solved it by wrapping loggedinuser() in touser() function as shown:
if( or(pv!Owner =loggedinuser ( ), contains(pv!Recipients,touser(loggedinuser())) ),1,0)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel