Open topic with navigation

Create a Prompt with a List of System Codes

When you build a prompt that displays a list of System Codes, the prompt will display a list of values pulled from a selected table of system codes. For example, you could build a prompt on the Critical Asset? field that presents the values Yes and No from a system code table in a query that returns pumps.

Steps

1. Access the Prompt Settings section of the Expression Builder window.
2. Define the prompt settings as needed.

3. In the Valid Values list, select Values From a System Code Table, and then select Next.

   The Values From a System Code Table section appears.

4. In the System Code Table list, select the System Code Table whose values you want to display in the prompt.
5. Select the Use Reference System Code check box if you want to specify a referenced System Code Table (i.e., a System Code Table that is referenced within the original table in the Configuration Manager). If you select this check box, then select values in the Reference Table and Reference System Code lists.
6. Select the Values are Exclusive check box if you want users to be able to choose only from the list of presented values in the prompt window. If you do not select this check box, users will be able to enter an alternate value for the prompt.

7. Select the Allow Multiple Selections check box if you want users to be able to select multiple values by which to filter the query results.

   Note: The Allow Multiple Selections check box is enabled only if you select the Values are Exclusive check box.

8. Select Next.

   The Configure Default Prompt Selection section appears.

9. If you want a particular value to be selected by default, then select the row containing the necessary value, and then select Finish.

   Note: You can select multiple default prompt values only if the Prompt Data Type is set to Character, and you selected the Allow Multiple Selections check box in the Values From a System Code Table section.

   The prompt appears in the Expression Builder window.

10. Select Done.

    The Expression Builder window closes, and then, in the grid in the Conditions section, <expr> appears in the field on which you created the prompt.

Results

• When a user runs the query, the prompt will contain a list of values as defined in the associated System Code Table.

Copyright © 2018 General Electric Company. All rights reserved.