About the Prompt Settings Section

Using the Prompt Settings section of the Expression Builder window, you can define the basic settings for the prompt that you want to create.

Prompt Settings

Setting	Description	Notes
Prompt Caption	A label that will indicate to the user what type of value to enter or select for the prompt. The prompt caption will appear on the Enter parameter values window to identify the prompt.	Prompt captions are optional. If you do not provide a prompt caption, the prompt ID will be displayed on the Enter parameter values window, where spaces are replaced with underscores. For example, a prompt ID of Task Type would be displayed as Task_Type. If you do not specify a prompt caption or a prompt ID, the text Enter Parameter Value will be displayed on the Enter parameter values window.
Prompt Data Type	A property that identifies type of data that exists in the field at the time the query is run. Expressions may exist that convert the stored value to a runtime value (e.g., numeric values may be converted to character values or strings). You will want to choose a data type for the prompt that is appropriate for the runtime value. When you access the Prompt Builder, this setting will be set by default to the data type that corresponds to the stored value of the field from which you accessed the Expression Builder. You may need to change the default setting. The following options are available: Logical: For logical values (i.e., True and False). Character: For character values. Number: For numeric values. Date/Time: For date values.	When you create a prompt that allows multiple selections, you can select multiple default values for that prompt. Multiple default selections will be allowed only when the Character option is selected for this setting. For prompts on numeric fields, the corresponding UOM will be displayed in the Enter parameter values window for that field if the Number option is selected for this setting. If you select any other option, the UOM will not be displayed. The Logical option is enabled only if you accessed the Prompt Builder from a Boolean field.
Prompt ID	A unique, alphanumeric ID for the prompt. This value is used internally by Meridium Enterprise APM to identify the prompt.	This setting is optional, but we recommend that you specify an ID for each prompt.
Valid Values	An option that defines the type of user-input value that will be required for the prompt. You can require users to specify a value manually, or you can present them with a list of valid options. Specifically, you have the following options for determining user-input values: No Valid Values: The prompt will not offer a list of values. Rather, the prompt will display a text box into which users can type the value by which they want to limit the results. Static List of Values: The prompt will display a static list of values that you define specifically for the prompt. Values from a System Code Table: The prompt will display a list of values that you define specifically for the prompt. Values from a Query: The prompt will display a list of values taken from the query results of a query that you select. Distinct List of Values From [X]: The prompt will display a list of values pulled from field X of all records in a given family.	When the Logical option is selected for the Prompt Data Type selection, the Valid Values options will be disabled, and a list of valid values will be created automatically, providing the options True, False, and All (i.e., both True and False) when the query is run.