124277 - no subject - Hi, \nWe came across an issue when we u

Howard over 10 years ago

Hi,
We came across an issue when we updated a process with some new variables and added them to a new column in an existing portal report. We tried the following expression in the that column, if(isnull(pv!newVariable),"N/A",pv!newVariable). It only displays a value for processes that were started after the update (which is expected), but ones that are inflight or completed show a blank. Has anyone come across this or have a suggestion on how to do this? Thanks....

Discussion posts and replies are publicly visible

0 Mike Cichy
Appian Employee
over 10 years ago

Use index(pv!newPV, pv!newPV, "n/a").
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Howard over 10 years ago

Thanks, I was able to use the index() function to set a value if the variable doesn't exist.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel