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
4 replies
Subscribers
5 subscribers
Views
1042 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Hi, I'm using getdatasubsetdownloadlinkfromrule to allow users to
anushaj
over 8 years ago
Hi,
I'm using getdatasubsetdownloadlinkfromrule to allow users to export report data to Excel. I am facing two issues :-
1.) It is not fetching data in case of nested CDT.
My CDT Structure : data=[id=41, acknowledgeFormU4=Yes, requestDetails=[id=4788, requestId=41042, requestStatus=Completed, workflowStatus=Completed - Approved, createdDate=9/14/2015 3:06 PM GMT+05:30, lastModifiedUser=Licensing BO1, createdBy=priyafa, requestClosedDate=9/14/2015 3:46 PM GMT+05:30, requestor=, accountNumber=, serviceRequestType=Change Of Address, mainCategory=Compliance Disclosures, subCategory=Change Of Address, signature=, boUser=, onBehalfOf=, accountName=, accountType=, amount=], complianceUser=, compUserApprovalDate=];
Here I have a Child CDT “requestDetails” from which I have to retrieve data. By using dot operator , I can display data in grid but not able to display in excel. It is giving me blank columns in excel. Please suggest, if there is any way to display ...
OriginalPostID-168125
OriginalPostID-168125
Discussion posts and replies are publicly visible
0
anushaj
over 8 years ago
...data from child CDT in excel.
2.) I have one column for created data. I am displaying data in grid, it is showing date and time in format “9/14/2015 3:06 PM GMT+05:30” but when am displaying same in excel it is coming in format ” 9/14/2015 2:43:42 PM”. Issue is not only with format but a different time is coming with the same query rule. Please suggest if there is any solution to make it consistent.
Thanks
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 8 years ago
Does this mean that you've resolved
forum.appian.com/.../e-168124
and the time is no longer null but still incorrect?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
anushaj
over 8 years ago
No these two are different. The issue reported in
forum.appian.com/.../e-168124
is related to filter value that user will select and on the basis of user selection data will be filtered.
This issue is different. In this , the format of data and time field which is being displayed in report(grid) and in excel is coming different using the same query rule.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 8 years ago
Is it the format only? Or the value itself? can you try wrapping the retrieved date in the local() function if possible? (unsure if you can do it in your SAIL)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel