Question

Populate data in a grid by passing parameters(one of column)

Hello,

I am having a requirement of populating a column in a grid but selecting another column.

  • Say I am having two data types DT1 and DT2 . In DT1 I am having list of records.
  • Now in work class I am going to created a Page list property by giving DT2 as source.
  • DT1 and DT2 are having two similar columns (Date and Swiped Hrs)

When I am going to choose a property defined in DT2 I need to get the data accordingling from DT1 records. How could I achieve this requirement?Could any one help me resolving this requirement.

Thanks in advance.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

January 5, 2018 - 4:16am

Hi 

If you select the Date and Swiped Hrs anyone of the two property should we receive all the data related to these two columns in the DT1

Is that the same thing you are referring?

Thanks

Prasanth

January 5, 2018 - 6:19am
Response to prasanthkumar

Hello Prasanth,

If i select Date i should get only swiped Hrs  value from DT2 to the columns of DT1 and by the way Date is my parameter.

Thanks,
Suhita

January 5, 2018 - 7:08am

Hi Suhita,
Both the Data Types will have their individual DataPage of type list.
You can change the default Datapage to accept parameters that is required and then can get any required values from either data Type. You can copy the value to target List as well if required.

Thanks,
Ujjwal

January 8, 2018 - 6:46am
Response to UjjwalShukla_GCS

Hello Ujjwal,
I have configured a Page List property with a report definition as its source where I kept my desired parameters as filter. I kept the refresh strategy as when referenced. But its not working for me. Then I went for writing a data transform, here I came to know as both my data types possess different properties I couldn't copy data from one Page List to other. (Please check the below attached image)

Is there any solution to copy data between two data types with different properties.

Thanks in advance.

Pega
January 8, 2018 - 1:24pm

Hi SriSuhita,

You can use define class joins on Data Access tab of the report definition to enable reporting on data from multiple classes or tables. 

You can alternatively use Subreports which enable results from any report definition (including a report definition defined on a different Applies To class) to be referenced and included in another report definition. 

You can find more information from the below Pega Help link.

https://pdn.pega.com/sites/pdn.pega.com/files/help_v731/procomhelpmain.htm#rule-/rule-obj-/rule-obj-report-/rule-obj-report-definition/dataaccess.htm?Highlight=Join

Hope this helps with your report definition issue.

Thanks!