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

Parents

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

Reply

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

Children

No Data