How to create a drop down list in a form that reads data from a database field?

book

Article ID: 50145

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Process Automation Base

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>

Figure 1

Values is a hidden parameter that will be populated by the process with the database values.

<Please see attached file for image>

Figure 2

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>

Figure 3

The process looks like this:

<Please see attached file for image>

Figure 4

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>

Figure 5

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>

Figure 6

<Please see attached file for image>

Figure 7

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>

Figure 8

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>

Figure 9

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>

Figure 10

Select Reply and see the following:

<Please see attached file for image>

Figure 11

Environment

Release: ITPASA99000-3.1-Process Automation-Add On License for-CA Server Automation
Component:

Attachments

1558698990422000050145_sktwi1f5rjvs16oi7.gif get_app
1558698988585000050145_sktwi1f5rjvs16oi6.gif get_app
1558698986857000050145_sktwi1f5rjvs16oi5.gif get_app
1558698984954000050145_sktwi1f5rjvs16oi4.gif get_app
1558698983118000050145_sktwi1f5rjvs16oi3.gif get_app
1558698981288000050145_sktwi1f5rjvs16oi2.gif get_app
1558698979290000050145_sktwi1f5rjvs16oi1.gif get_app
1558698977505000050145_sktwi1f5rjvs16oi0.gif get_app
1558698975535000050145_sktwi1f5rjvs16ohz.gif get_app
1558698973655000050145_sktwi1f5rjvs16ohy.gif get_app
1558698971677000050145_sktwi1f5rjvs16ohx.gif get_app