Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
2 subscribers
Views
1450 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
60950 - no subject - I have process report wherein there is a
radhikak
over 12 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!...
OriginalPostID-60950
Discussion posts and replies are publicly visible
0
Sathya Srinivasan
Appian Employee
over 12 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 12 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 12 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 12 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 12 years ago
No it won't be.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel