Question
Displaying external database values in a dropdown
I am new to Pega and I am trying to build some simple screens to prepare for a project. What I have done is created an external class map to a table in the database which will continue to serve as a system of record. I want to list one of the columns of this table as the values in a dropdown so the user can select it in order to bring up a specific record in the table and display it for editing. I have the activities built that will retrieve that data and should display it, but this dropdown is the current stumbling block. I've seen similar questions on here, but I have not seen any concrete steps on how to set it up. How do I take a column from an external database class and display it in a dropdown?
***Edited by Moderator Marissa to update categories***
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://pdn.pega.com/community/product-support/question/how-put-data-coming-external-database-dropdown-item