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 ...

Discussion posts and replies are publicly visible

Parents

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

Reply

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

Children

No Data