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.
Booz Allen Hamilton
US
So I ended up creating Report Definition on top of External Data Class, then a Data Page on top of Report, and then tied the picklist to the Data Page.
Think there may be a shorter way. Perhaps don't need Data Page. However, then if I directly go to Report Definition it will load the list values every time.
Wish PEGA provided a more simpler way for this very common use case. Or maybe it is there, I just don't know about it.
Pegasystems Inc.
IN
What you did seems to be the right way. Data Pages are meant to be used for these kind of purposes. We should use Data Pages wherever possible as they provided optimized way of accessing and caching data.