PromptSet Combobox Elements

A Variable object that along with rest of the prompt fields specifies the prompt's allowable values.

The drop-down menu only includes Variable objects as a reference that have a suitable data type for the PromptSet element. The data type of the data reference variable for Combobox prompts must be one of the following:

• Text
• Number
• Time
• Date
• Time stamp

Reference values from the Variable object specified as the data reference retrieves either: 

• For static variables: The first value column
• For dynamic variables: The RESULT column

Do not edit data reference variable objects when executing objects with PromptSets or while those objects are starting. At this time, the prompt interface has already been generated and editing variable objects will cause problems.

If the values specified for a PromptSet element do not comply with the reference values, the prompt cannot be sent after object activation. More information is provided in the topic PromptSet Activation.

If you use dynamic variables (except for the source "Filelist") as the data reference: The number of entries that is returned by dynamic Variable objects is limited by the setting in the SQLVAR_MAX_ROWS variable UC_SYSTEM_SETTINGS (default value 200 lines).

A key from the Key list of the XML variable selected the Data Reference field.

This field is only available when you select an XML variable in the Data Reference field. It allows variables.

XPath/XQuery

The XPath or XQuery expression of the XML variable selected the key. Indicate each level with a / character.

For example, assume the following: 

• An XML variable is selected in the Data Reference field.
• The XML variable includes a key, which is selected in the Key field.
• The key includes the following XML: 

<server>

    <name>MyUNIXServer</name>

    <ip>19.16.8.1.200</ip>

</server>

To specify the ip for server, you would enter server/ip.

This field is only available when you select an XML variable in the Data Reference field. It allows variables.

The descriptive text that will be the label for the prompt.

The name of the PromptSet variable that executable objects will create each time they run this prompt. A PromptSet variable is a form of a Script Variable that is defined in prompt and used in the executable object's Process Pages. PromptSet variables can be used similarly to Object properties variables. They can be modified, inherited etc. PromptSet variable names are written in uppercase and specified with a leading & and a closing #. When you add a prompt to the PromptSet, the PromptSet variable is given a default name, which you can change.

When the data reference is an EXEC type variable, the name of the PromptSet variable must match the script variable set as the parameter name in the EXEC variable object.

The default prompt value. You specify the default prompt value by picking an option from the radio button list and entering a value in the field below it. There are two options: 

• Set Manually: This field allows text and variables.
• Set by Variable: This field allows text and variables. It includes a button on the right side of the field. You can use it to insert variables using the Insert Variables dialog.

Unless it is limited by the text length property, the length of the default value is not limited. Blanks at the end of the text are truncated.

You can save the PromptSet even if it includes prompts with default values that do not use the data references' data or adhere to the limitations specified in the prompts' settings. The resulting error will only occur when the attempt is made to save the object where the PromptSet is assigned.

The prompt value can be overridden in multiple places. The order of precedence of the prompt value used for activation is:

1. The default value (if one is set here).
2. The prompt on the Prompt Sets page under Variables & Prompts in an executable object's definition overrides the default value.
3. An override of the activation of the instance of a Workflow or other executable object when it is run:
   • Manually with an Execute command.
   • Via a Schedule object.
   • Via a ACTIVATE_UC_OBJECTscript element with the parameter PASS_VALUES using :PUT_READ_BUFFER, :PUT_PROMPT_BUFFER.

   Note that the read buffer variable requires the same name as the PromptSet variable (Properties - Variable name). A Request dialog for prompts is not displayed for tasks that are activated through Workflow, Schedule, or Script objects.

Puts this prompt into focus when the PromptSet is viewed. If this option set for multiple prompts, the focus is set to the last prompt with this option selected.

This is an additional field in which you can enter any text of your choice.

It does not affect the functionality of the PromptSet element.

This option does two things:

1. If the data reference value is a dynamic Variable, the list of values for the combobox is always newly resolved when the combobox is called. The list content is directly retrieved from the data source when it is opened. This behavior affects the PromptSet object's preview, the Variable & Prompts > Variables page for executable objects and the Request dialog at runtime.
2. You can use the value of an earlier prompt in this PromptSet in allowable fields in the data reference Variable of this prompt.

You can use an earlier prompt's value by entering the variable specified in the Variable Name field of that prompt in any of the following fields in this prompt's data reference Variable object definition:

• BACKEND: Agent, Login, and the OS Command columns
• EXEC: Parameters
• FILELIST: Agent, Login, and Files
• SEC_SQLI: Oracle Statement, SQL Server Statement, and DB2 Statement
• SEC_SQL: Connection, Login, and SQL statement
• SQLI: Oracle Statement, SQL Server Statement, and DB2 Statement
• SQL: Connection, Login, and SQL statement

If you want to use PromptSet variables in Variable objects, you must ensure that the value 3 is set in VAR_SECURITY_LEVEL (UC_SYSTEM_SETTINGS). Note that this limitation does not apply to the SQL statements of VARA objects that use the sources SQL SECURE and SQLI SECURE.

This option is used to automatically unset the value of other Text Field, Combobox, and/or Checkbox prompts in this PromptSet when a user selects a value for this prompt.

When other Text Field, Combobox, and/or Checkbox prompts are defined in this PromptSet, there will be a checkbox listed for them. Each prompt you check the checkbox for will be unset when a user selects a value for this prompt. Even if the selected prompts have default values, they will be unset to have no value.