Posted: 29 May 2019 12:56 EDT Last activity: 16 Jul 2019 3:35 EDT
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.
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.