Question
Cognizant Technology Solution
IN
Last activity: 3 Jul 2019 2:09 EDT
Populating Dropdown list from a view created in external Database
I have a requirment where I have to populate a dropdown list froma Database view. How to do that?
***Edited by Moderator: Lochan to update platform capability tags***
Pegasystems Inc.
IN
Hi,
You can source the Drop down using various ways.
For the dropdown control , go to the properties panel and here we can see the List Source.
Under the list source we have various option out of which we can opt for any one.
If you have external DB then you can use a Report Definition to fetch the Data Base and use that for the source of the dropdown.
The below link may help you
https://collaborate.pega.com/question/how-put-data-coming-external-database-dropdown-item
Thanks.
Cognizant Technology Solution
IN
I understood this part of the requirement where I shall be fetching data in the dropdown through a Report definition as explained by you. But how can I map the class of the report definition with the external view?
TSPi
IN
The best practice to populate the data is use Data page.
https://collaborate.pega.com/question/populate-drop-down-using-data-page-source
The above link will help you