60950 - no subject - I have process report wherein there is a

radhikak over 11 years ago

I have process report wherein there is a column for process status. We are not using "=process_status()" directly as an expression for value in the column. But using =process_status() in an expression, we are fetching images from a multivalued constant and showing those on the report column. Due to this, when we export a report/ mail a report, the status column is seen blank. We cannot use only "=process_status()" as an expression because our processes never get completed due to quick tasks are active and hence setting a pv we show the process as completed by showing the image from constant.

Any solution on how we can get "Status" column populated/ filled in mail or export from report?

Thanks!...

Discussion posts and replies are publicly visible

0 Sathya Srinivasan
Appian Employee
over 11 years ago

Can you add a pv! to your process and use this to set the status at different milestones within your workflow?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 radhikak over 11 years ago

Text pv right? Yes that can be done, but then a column must be added for that pv in the report on the dashboard. Then, there will be 2 columns one <status image> and other <status text>. Is there not any way to show image column in report on dashboard, but in email a text column/image column similar to the one we get using only "=process_status"? Is there any solution using solely an image column instead of a text column?

Thanks in Advance!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sathya Srinivasan
Appian Employee
over 11 years ago

You will create an expressio rule based on the value of the text PV that displays the corresponding image. Let's say you have 2 images, Both are uploaded in the Appian document management system and you have created a constant to point to these images (say ICON_GREEN and ICON_RED)- Let's also assume that your status pv! contains the value 'Progress' and 'Complete' mapping to these two icons respectively. Then, your expression will look something like this
if (pv!status ='Complete',cons!ICON_GREEN, cons!ICON_RED). You can extend this to cater for additional statuses.
For the column in your report, use this expression as the 'Data' and the Column type to 'Image'. This should do the job.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 radhikak over 11 years ago

Thanks Sathya. Will the images from the constant be seen the email in this case?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sathya Srinivasan
Appian Employee
over 11 years ago

No it won't be.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel