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
10 replies
Subscribers
11 subscribers
Views
2585 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
I have a case to show employee records on Tempo report. The record data get from
heriz
over 10 years ago
I have a case to show employee records on Tempo report. The record data get from Data Store. Can I show the image of each record list with initiator image? How to do that? ...
OriginalPostID-92512
OriginalPostID-92512
Discussion posts and replies are publicly visible
0
Patty Isecke
Appian Employee
over 10 years ago
Are you storing the initiator into your data store as well?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
heriz
over 10 years ago
Hi, I store the initiator email address on data store. But I am not store the initiator image. So, I think I need to get initiator profile picture on user directory. Any advise?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ajinkyab277
Certified Lead Developer
over 10 years ago
You can store initiater username in database and in record list view you can use touser function .
e.g
rule!APN_listViewTemplateUser(
rf!title,
rf!description,
rf!timeStamp,
touser(rf!initiaterUserName)
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
heriz
over 10 years ago
Hi, I've tried to using this expression on List View Template :
=rule!APN_listViewTemplateUser(
title : rf!nameEmp,
details : rf!department,
user: touser(rf!emailEmp)
)
----------
source type : Data Store Entity
source : empDetail (my datastore source)
sort field : dateInput ---> one of my datasource field
sort order : Descending
--------
after doing this, its show me an error :
"could not display record".
Any suggestion? Thanks before.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ajinkyab277
Certified Lead Developer
over 10 years ago
in touser function give username of initiater, so u need to store username of the initiater in database. touser(rf!emailEmp) is wrong expression as u r passing email id to the function.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
heriz
over 10 years ago
i just change rf!emailEmp to rf!inputBy, and its still have same error. inputBy (is username of the initiator). any option that we need to set in CDT or data store. Because the data error to show up.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ajinkyab277
Certified Lead Developer
over 10 years ago
you need to create inputBy field in u r cdt . and make sure that all the username stored in database in inputBy column should be present in appian
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
heriz
over 10 years ago
hmm.. I had store inputBy field in CDT and have the same reference to appian. But it's still have the same issue. the data not show up.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ajinkyab277
Certified Lead Developer
over 10 years ago
Can you check following rule is present or not in your environment.
rule!APN_listViewTemplateUser
if no rule is present by such name you can use below expression
type!ListViewItem'(title: ri!title, details: ri!details, timestamp: ri!timestamp, image: rf!inputBy)
2. You can test your expression by hard coding the username
type!ListViewItem'(title: ri!title, details: ri!details, timestamp: ri!timestamp, image: touser("ajinkyabendre"))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
heriz
over 10 years ago
Hi, its strange in here. I have checked that the rule (rule!APN_listViewTemplateUser) is stored in my environment, and tested the rule that you provide before and its no issue.
Its error when I want to show the data on record only. maybe its something problem with my CDT or data store?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel