Input Query List (Parameter Update Method)

Choose this Update Method if you want to feed the parameter with an input dialog box displaying several today's values (real time), the user being able to select one or several values in the proposed list. Important: the first column in the list of values must be the one used as the criteria value. Other columns (optional) can be displayed only for information.

You can if necessary make that parameter mandatory so that the user will not see the <Ignore> button

You can also decide if that parameter can be modified or not. If it is not modifiable, only the list values can be authorized. If it is modifiable, the user will get an input box above the list of values to make any modification or direct input.

 

In any case you can also specify a customized title to be displayed when prompting the value(s) for the parameter.

The List of value(s) can be feed with 2 methods: enter an SQL command to get the required values, or use a query made with ClicknDECiDE Builder. If that Query file already exists, you can use the browse button to look for it.

You can also specify if several values are accepted or not, choosing among All, Single, Multiple or Extended selection option (All, Single, Multiple or Extended).

 

Query entered manually

Query feed by an existing Query

image\parameterinputquerylist.gif

image\parameterinputquerylist2.gif

 

When running the query, the user can ask for the real time list of values and select the proposed values, selecting one or more rows according to the selection option (All, Single, Multiple or Extended) and enter or modify a value only if the parameter is Modifiable.

 

Query entered manually and Multiple selection

Query feed by an existing Query and Extended selection

image\parameterinputquerylist4.gif

image\parameterinputquerylist3.gif