Question

How to automatically view data result dynamically from external database without using UI/Case/Action?

Good day everyone, 

I'm using both external database and internal database to integrate each other. External database is read-only, while internal database is dynamically change depends on the data in external database. (Ex: I want to sum the value property inside external, so I put it into property from internal database).

So it's like this, External is Page List and Internal is Single Page. The data inside Internal Database is change everytime the data from external database modified/manipulate(DML). We don't use any case or UI so we need to do this automatically.

I've tried using data page internal(D_Internal) to contain both table from data source using activity but when I run the data page, I got no data result.

Inside my activity that I used, I put RDB method and when I run the activity, I got the result that I want.

Can anyone help me what's wrong or missing? Thanks. (PS: The Internal Data page will be used in mobile)

 

Best Regards,

Jimmy

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

Correct Answer
November 15, 2016 - 10:59pm

Hi Prudhvi,

"using data page internal(D_Internal) to contain both table from data source using activitymeans when I test it to run from the D_Page. (data source:activity)

"Inside my activity that I used, I put RDB method and when I run the activity" and this is when I test from Activity. (without D_Page)

Finally, I've discard to use activity data source and using ReportDefinition as datasource and it works. (using function, function alias, class joins and param)

Thanks,

Jimmy

Comments

Keep up to date on this post and subscribe to comments

Pega
November 15, 2016 - 1:08am

Data Page is a good approach, besides have you check the external mapping to the class mapped to external db table? you can check database class mapping landing page. Make sure you have a database rule defined to connnect to external DB.

You can source a report definition rule as a source to data page to get the results from the external DB table.

 

 

Pega
November 15, 2016 - 1:33am

Hi Jimmy,

Can you please clarify the below statement.

"I've tried using data page internal(D_Internal) to contain both table from data source using activity but when I run the data page, I got no data result.

Inside my activity that I used, I put RDB method and when I run the activity, I got the result that I want."

In the first sentence, you said activity is not returning any result. And in the second, you said you are getting the desired result. 

Thanks,

Prudhvi

November 15, 2016 - 10:59pm
Response to Prudhvi_N

Hi Prudhvi,

"using data page internal(D_Internal) to contain both table from data source using activitymeans when I test it to run from the D_Page. (data source:activity)

"Inside my activity that I used, I put RDB method and when I run the activity" and this is when I test from Activity. (without D_Page)

Finally, I've discard to use activity data source and using ReportDefinition as datasource and it works. (using function, function alias, class joins and param)

Thanks,

Jimmy

November 15, 2016 - 1:47am

Hi Jimmy,

Without using UI/Case/Action where do you want to view the results returned from the external db.

If you are using D_Page it need to be referred some where to get it called.

November 15, 2016 - 10:50pm
Response to Raghunatha_Incessant

Hi BendeRaghunath,

The D_Page isn't called in PEGA but in another application third-party as a web service for mobile java.

It only contain list data which has been query.