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
7 replies
Subscribers
5 subscribers
Views
2551 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Hi We are using Export Report Data to Excel v2 (Export SQL and Report Data
rupakj
A Score Level 1
over 9 years ago
Hi
We are using Export Report Data to Excel v2 (Export SQL and Report Data to EXCEL - V2_3.0.6) to transfer portal report to excel.
We are getting blank (no data) for Assignee Column in excel report. All other columns generating correctly. Please find enclosed server logs.
Any help would be appreciated.
Regards,
Rupak Jha
server logs.txt
OriginalPostID-154326
OriginalPostID-154326
Discussion posts and replies are publicly visible
0
Sathya Srinivasan
Appian Employee
over 9 years ago
Can you try converting the names to a string using "toString" just to check if that populates the data?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rupakj
A Score Level 1
over 9 years ago
Hi Sathya
After converting the names to toString [=tostring(pv!assigneeCompletions_UserGroup)], it changes to userId/GroupId. Yes it is populating the userid/groupid to excel report not User Name /Group Name. for eg. It is populating 'rupakj' not 'Rupak Jha'. Please find enclsoed screenshot.
Regards,
Rupak Jha
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 9 years ago
Groups are held as numbers & names are held as user_name string. That's what you are seeing here when you convert the value to a string.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rupakj
A Score Level 1
over 9 years ago
Thanks for the quick response..
Yes, that is correct but we need to populate the names and group names to excel report to make it meaningful. Any idea how to achieve this.
Regards,
Rupak Jha
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Andrew P Gramann
Certified Lead Developer
over 9 years ago
You can write an expression rule that
1) Checks to see if the first character in the returned string is a "["
2a) If yes, uses the group() function to get the group name
2b) if no, uses the user() function to get the the first or last name of the user
3) Use apply() to iterate this rule over your list of Users or Groups
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rupakj
A Score Level 1
over 9 years ago
Hi Andrew,
I have created an expression rule - rule!GLOB_getUserOrGroupNameFromString and using the apply in Column definition to iterate it "=apply(rule!GLOB_getUserOrGroupNameFromString(_),{tostring(pv!assigneeCompletions_UserGroup)})". but it is returning blank column. I have already tested the expression rule and it is returning name/group name as required but getting blank column while using it in report.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Andrew P Gramann
Certified Lead Developer
over 9 years ago
The user() and group() functions are part of the Appian Scripting functions category (
forum.appian.com/.../Appian_Functions.html
that aren't to be called in portal reports. You'll need to store the report data in process variables before applying your display formatting / inserting it into the excel file.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel