About Prompts on Queries

You can create a prompt on a character, numeric, date, or logical field in any type of query (Select, Crosstab, Append, Update, or Delete). Like all query options, you can construct prompts by modifying the SQL code directly, but Meridium Enterprise APM provides the Prompt Settings section of the Expression Builder window, which guides you step-by-step through the process of creating prompts. This documentation focuses primarily on that feature.

Note: There are special considerations to take into account when you create a prompt on a date field.

When a user runs a query by opening it from the catalog, prompts appear in a window that disappears when the query results are returned.

If you create a prompt on the Asset Manufacturer field to limit the query results based on the manufacturer, when the query is run, a window appears, prompting the user to supply the desired value for the manufacturer.