How to open data from two table of a customer using activity?

User Experience
, ,
1

Hi Everyone,

I have 2 Tables One table Personal Details Table and 2nd is Bank Details Table. My requirement is to show the Data from both table using Activity. How to achieve this?

2

@Nagarjuna Saidu

I think your scenario is about joining 2 tables, if yes, then join 2 tables using class join in Report definition and use pxRetrieveReportData activity to call the report in activity.

3

@Nagarjuna Saidu

Hi

We can fetch the data from two data tables by using an Obj-open method in an Activity.

Steps: Create an Activity

  1. Create a new page by using Page-New method.

  2. Use Obj-Open method to open the particular record by passing the required parameters and give the step page. (Get the personal details)

  3. Create a new page by using Page-New method.

  4. Use Obj-Open method to open the particular record by passing the required parameters and give the step page. (Get the bank details)

  5. Use Page-Copy method to copy the results of two new pages into target page.

Thanks

4

@Anoop Krishna Thank You for your response. How to fetch single customer data Like Customer details with respect to Account details and the two tables having two different primary keys. The tables having multiple records

5

@Nagarjuna Saidu you can create report in customer class and join with Account details class. Primary key would be different, but there should be some reference in Account details class to join with Customer details. In class joins you have option to fetch all the matching rows.

To report you will be passing customer details key. Then within report you will be joining with account details class with the reference key.