Autoprompt how to#

Dynamic list values that display in Responsive Autoprompt are organized in a case-insensitive sort order.Such as SET commands, needed to obtain the values from the specifiedĭata source must be issued in the WebFOCUS Server profile, user The values using the specified data source. In one or more static values, put the values in a file and use theĭynamic lists, the WebFOCUS Client constructs the request to obtain The WHERE statement syntax because the comma character (,) is the delimiterĬharacter for specifying a display value. Static value cannot contain the comma character (,) when specified within Restrictions, see Adding a Variable Description to a Filter. Is an optional description of the variable. Same name as the field name in the Master File. The second and subsequent fields in the chained group must be a dynamic filter The filters shouldīe in the order that the fields are referenced in the Master File in a dimension hierarchy. Is required for the first field in a chained grouping that is created for fields within the The WITHIN attribute is for chaining supported with the Responsive Autoprompt template. The FORMAT attribute is for all filter types.

Autoprompt how to#

Specifies how to evaluate the variable for validation and sorting. Is the variable, including the ampersand (&), for whichĪre the values comprising the list of selectable variable values. Is the name of the hidden variable, including the ampersand (&), for which the Manager line, if that phrase is coded across multiple lines.įor more information on FOC_NONE, see Internal Processing of FOC_NONE. However, this process may not remove an entire filtering phase (such as BY or WHERE) that begins on a non-Dialogue Internal processing removes all non-Dialogue Manager lines (those lines that do not begin with a '-' dash) that contain the In this case, when users select either of these options, The default value FOC_NONE also allows users to make a parameter-based filter selection optional by including the All Values option in selection lists based on the Responsive Autoprompt template or the Select All option in selection lists based on the HTML Autoprompt template. When users select either of these options, internal processing selectively removes WebFOCUS filtering phrases (such as BY and WHERE) from that parameter before passing the procedure to the core WebFOCUS engine to run the request.įor more information on _FOC_NULL, see Internal Processing of _FOC_NULL. The default value _FOC_NULL allows users to make a parameter-based filter selection optional by including the All Values option in selection lists based on the Responsive Autoprompt template or the Select All option in selection lists based on the HTML Autoprompt template. Is enclosed in quotation marks, such that the beginning and ending of the string has three (3) quotation marks. For example, in theįollowing example, each of the values within the string are enclosed in two single quotation marks (' ') and the entire string In addition, the entire string must be enclosed in single quotation marks ('). In two single quotation marks (' ') and include the operation used in the filter the variable is referenced in (for example, To specify multiple default values for a variable that will be used with a multiselect filter, each value must be enclosed Quotation marks are requiredĪround variables containing delimiters, which

Marks are indicated by two contiguous single The beginning and end of the description value. Specifying the pipe character (|) immediately after the & characterīe used in a description because a period is the delimiter to specify

Is a description of the variable that replaces the variableĬharacter is supported within the description for a variable by The QUOTEDSTRING suffix on the variable, instead of enclosing the value in single quotation marks. If the variable value contains a single quotation mark ('), use Quotation marks to be handled by most database Character strings must be enclosed in single If the variable value will be compared to anĪlphanumeric field, you must enclose the variable in single Is the variable name, including the ampersand (&), for which the