Defining retrieved values for web service prompts - HxGN EAM - 12.0.1 - Help - Hexagon

HxGN EAM Help

Language
English
Product
HxGN EAM
Search by Category
Help
HxGN EAM Version
12.0.1

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.

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.

  1. Select Administration > Web Service Prompt Engine > Web Service Prompts.

  2. Select the web service prompt for which to define retrieved values, and then click the Retrieved Values tab.

  3. Click Add Retrieved Value.

  4. Specify this information:

    Source - Specify the source field sequence.

    Destination - Specify the field sequence for which to populate the retrieved data.

    Query Code - Specify the query code on which the retrieved value will be based. SQL Statement is automatically populated.

    Referencing other prompt fields inside the user-defined SQL statement is allowed. 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".

  5. Click Submit.