Create a Prompt with No List of Valid Values

When you build a prompt that presents no list of values, the prompt will display a text box into which the user can enter a value to limit the query results. For example, you could provide a prompt that presents no values for the Asset Type in a query that returns pumps. When presented with this prompt, the user would have to enter an Asset Type in the text box. To limit the results in this way, the user must be familiar with the exact values that exist in the limiting field.

Steps

Access the Prompt Settings section of the Expression Builder window.
Define the prompt settings as needed.
In the Valid Values list, select Prompt Has No Valid Values, and then select Next.

The Configure Default Prompt Value section appears.
In the Default Prompt Value box, you can enter a default value for the prompt that will appear when a user runs the query, then select Finish.

Note: You can select multiple default prompt values only if the Prompt Data Type is set to Character. If you do not want to provide a default value for the prompt, you can leave the text box blank.

The prompt appears in the Expression Builder window.
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 appear. If you specified a default prompt value, that value will appear in a modifiable text box.
If the user enters a value that does not exist in the limiting field, the query will not return any results. For example, if two asset types exist in the results, such as Rotating Pumps and Centrifugal Pumps, and the user enters Reciprocating Pump, the query results will be empty.