https://answers.axonivy.com/questions/1823/db-table-to-populate-a-list-of-values<p>Hi all,</p> <p>I'm newbie about AI designer. I'm trying to do something that it should be easy. I want to load a list of values in a Dialog (selectOneMenu) from a DB table. Suppose I have some employees. I want to create a new employee, so I need to assign it to amn existing department. So, I need an object List&lt;department&gt; in the Dialog interface to use it in the selectOneMenu control and save department code when I save this employee data to database.</p> <p>I'm not finding the way to connect the DB step when I make this query to the dialog step.</p> <p>Can you help me? Any documentation about this kind of tasks?</p> <p>BR</p>enMon, 27 Jun 2016 10:30:08 -0400https://answers.axonivy.com/questions/1823/db-table-to-populate-a-list-of-values/1847<p>Hi You can use the database element to load the values from the database and store them in a Recordset. Then use the values in the Recordset on the Dialog.</p> <p><strong>Example:</strong></p> <p>HTML Dialog with the following Data Class <img alt="alt text" src="http://answers.axonivy.com/upfiles/DataClass.PNG"></p> <p>The Recordset users is loaded by a Database Process Element from a Table in a database. The we use this Recordset in the View like this:</p> <pre><code> &lt;p:selectOneMenu value="#{data.userId}" &gt; &lt;f:selectItems value="#{data.users}" var="user" itemLabel="#{user.getField('FullName')}" itemValue="#{user.getField('UserId')}"/&gt; &lt;/p:selectOneMenu&gt; </code></pre> <p>The value that is displayed is the column <code>FullName</code> of the table (itemLabel). The value that is selected is the column <code>UserId</code> of the table (itemValue). The itemValue of the selected record is stored in the variable <code>data.userId</code>. </p>Reto WeissMon, 27 Jun 2016 10:30:08 -0400https://answers.axonivy.com/questions/1823/db-table-to-populate-a-list-of-values/1847