Defining retrieved values for web service prompts

Create, edit, and delete retrieved values for a web service prompt. Values can be retrieved from the database and automatically populated into the Destination field when you enter data into the Source field. Using retrieved values saves data entry time and prevents potential key stroke mistakes.

A good example for using retrieved values would be when an employee regularly creates a work order and activity for which they will complete. When the employee enters his or her user name for the work order Created By field, the system can locate the employee associated with the entered user name and populate that employee’s Trade on the activity automatically.

Note: Setting up retrieved values requires identifying the Source, the Destination, and the SQL Statement used to query the information related to the supplied data. SQL statements can be defined on the Queries screen.

To define retrieved values for web service prompts:

Select Administration > Web Service Prompt Engine > Web Service Prompts.
Select the web service prompt for which to define retrieved values, and then click the Retrieved Values tab.
Click Add Retrieved Value.
Specify this information:

Source

Enter the source field sequence. The system automatically populates the source description.

Destination

Enter the field sequence for which to populate the retrieved data. The system automatically populates the destination description.

Query Code

Enter the query code on which the retrieved value will be based. The system automatically populates SQL Statement.
Note: The system allows referencing other prompt fields inside the user-defined SQL statement. The syntax is ":<prompt sequence #>. For example, if you want to reference a prompt field whose Sequence = "2" inside the ‘where’ clause of their SQL statement, enter ":2".
Click Submit.