Open topic with navigation

Create a Prompt with a Static List of Valid Values

When you build a prompt that presents a static list of predefined values, the prompt will display a list of values that you define specifically for the prompt. For example, you could build a prompt that presents three predefined values for the Asset Type in a query that returns Pumps, such as Rotating Pumps, Reciprocating Pumps, and Centrifugal 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 Static List of Values, and then select Next.

   The Static List of Valid Values section appears.

4. In the Enter List of Values box, enter the first value that you want to appear in the list, and then select . Repeat this step to continue adding values as needed. To delete a value from the list, select the corresponding .

   Note: If you are defining a list of values for a numeric field and you enter a non-numeric character in the list, then the Next button will be disabled. You will not be able to proceed or close the Prompt Builder until you replace the non-numeric character with a numeric value.

5. Select the Values are Exclusive check box if you want users to be able to select only from the list of defined values in the prompt window. If you do not select this check box, users will be able to enter alternate values.

6. 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.

7. Select Next.

   The Configure Default Prompt Selection section appears.

8. 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 Static List of Valid Values section.

   The prompt appears in the Expression Builder window.

9. 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 display the list of predefined values. The user will need to select a value to view the query results.

Copyright © 2018 General Electric Company. All rights reserved.