Question
Areteans
AU
Last activity: 11 Jun 2020 16:55 EDT
RD Column Format
Hi Team,
I have a table called reference data, data looks like below. I am using this data in another work object for a property called Lookupcode and I am using Dropdown and Data Page combination to capture code value and to display the value on the UI. Till now it is fine because I am using a section to display the value. But we have a requirement to export the work object rows using RD, in this case, while exporting it is only showing the lookupcode as "3" only, we want to show as "XYZ" by applying some Column Format or by writing custom control. Any help regarding this. If anybody has come across this scenario, could you please help us out.
| pyID | Code | Value | FieldName |
|---|---|---|---|
| Lookup_A | 1 | ABC | Lookup |
| Lookup_B | 3 | XYZ | Lookup |
| pyID | propertyA | propertyB | propertyC | LookupCode |
|---|---|---|---|---|
| id-100 | a1 | b2 | c3 | 3 |
***Edited by Moderator: Pallavi to change content type from Discussion to Question***
Updated: 9 Jun 2020 8:08 EDT
Areteans
AU
Pegasystems Inc.
US
How is the table in your work object populated ? is it from a data page / RD ?
Irrespective of that I suppose you have one column -- which is a drop down that is populated via a data page ?
If sourced from data page : I think this should help
https://collaborate.pega.com/discussion/export-data-data-page-excel
In step 3, make sure you update the dropdown property specifically after the Page-Copy
if sourced for report definition, you would have to update the contentPage before you pass it to Export to Excel
See screenshot
Areteans
AU
Hi Krithiga,
Thanks a lot for responding. However, my use case different. Please find the screenshots as follows.
We directly running RD on click on the button. We are looking for some column format that will take the MemorialScheduleTypeLookupCode and get the value. Please help us out to achieve this
Thanks and Regards,
Chiranjeevi Y.
Updated: 11 Jun 2020 16:55 EDT
Maantic Inc
US
Build a custom control, refer existing OOTB control FormatOperator to understand how it works.
Draft code for your scenario
<%
String memSch = tools.getActiveValue();
String memSchText="";
if (memSch == 3) memSchText ="XYZ";
tools.putSaveValue("result", memSchText);
%>
<pega:reference name='$save(result)' mode="NORMAL" />