Question
Hopkins Software Pvt. Ltd.
IN
Last activity: 5 Jul 2023 5:11 EDT
How to open data from two table of a customer using activity?
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?
Accepted Solution
Updated: 5 Jul 2023 5:11 EDT
Bits in Glass
IN
@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.
Updated: 5 Jul 2023 2:28 EDT
Bits in Glass
IN
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.
Hopkins Software Pvt. Ltd.
IN
@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
Accepted Solution
Updated: 5 Jul 2023 5:11 EDT
Bits in Glass
IN
@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.
Eclatprime Digital Private Limited
IN
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