Close popover
Saurabh Dixit (PEGAFREAK)
Bank of America
SVP Architecture
Bank of America
PEGAFREAK Member since 2013 9 posts
Bank of America
Posted: May 29, 2019
Last activity: July 16, 2019

Loading Picklist from External Database Table

Okay so I need some help understanding all the "Table type" configurations for a Pick list. Prompt List, Local List, and Field Value I get. The rest I don't. Here's what I've done so far.

I have a SQL Server instance in which I have a table. I have created an external class definition in my Int layer. The table has two columns, a Key (1,2,3) and a Value ("Mr", "Mrs", "Miss"). I was thinking Key useful to maybe use as the "value behind the picklist", but not really important now. I call it Salutation. I have created Database record and Database Class Mapping to my Int class which I call SAL. SAL has "Key" as an Integer and "Name" as a Text. The "Name" properties are for holding "Mr","Mrs","Miss.

What do I need to do to get the values in my SQL Server external table to show up in my Picklist? First need to understand which of Class Key Value, or Remote List is appropriate. I'm getting confused whether I also need a Report Definition, Data Page (since makes sense to cache values in that table), what else.

Perhaps I'm going about this all wrong. Appreciate any education.

Pega Platform Low-Code App Development Dev/Designer Studio Data Integration
Moderation Team has archived post