How to create a drop down list in a form that reads data from a database field?
Article ID: 50145
Updated On:
Products
Issue/Introduction
Description:
Building a CA PAM Interaction Request Form with a drop down list populated from a database field.
Solution:
The Interaction Request Form contains two variables. Values and LastName.
<Please see attached file for image>
Values is a hidden parameter that will be populated by the process with the database values.
<Please see attached file for image>
LastName is the parameter that will read from the Values parameter and present that in this form as a drop down. It uses the expression field to refer to the Values parameter.
<Please see attached file for image>
The process looks like this:
<Please see attached file for image>
The properties of the Select_Operator are shown below. The expression is in double quotes and just does a select of the last_name field from a contact table.
<Please see attached file for image>
On the Execution Settings tab of the Select Operator properties, the Post Execution will populate the process dataset variable, LastNames, with the values that are read from the database.
<Please see attached file for image>
<Please see attached file for image>
On the User Interaction Form Operator Properties, select the Assignee(s) that we are presenting the drop down list to on the Assingees tab.
On the User Prompt tab, select the Interaction Request Form that was created above.
<Please see attached file for image>
Select the Form data initialization code button and enter the following to pass the Process LastNames values to the Form's Values parameter.
<Please see attached file for image>
Now save and check in the process and run it. The assignee will see the following on their task list in the management console:
<Please see attached file for image>
Select Reply and see the following:
<Please see attached file for image>
Environment
Component:
Attachments
Feedback
