Input Types

When you create a Quick Query, you may specify not only that a given item may be input but also the method of input, such as a text field or drop-down selection box.

Most parameters of most table actions can be made inputs. For example, in a row selection like Column1 has the value 100, the value 100 can be an input. In this case, you have the option of making it a text field, a drop-down selection box, or a multi-value selection box. In the first case, when the query is run, the user will be asked to type a value (e.g., 100). In the second, the user will be presented with a list of all possible values in Column1 and will be able to select a value from a list. In the third case, the user will also be presented with a list of all possible values, but will be able to select one or more values. The choice of input types for a given item depends on the type of action and parameter.

You may also specify whether a given input item is optional or required. If an item is optional, the user may leave it blank, which, in turn, causes the query to run without that item. The result of leaving an item blank depends specifically on the type of action and parameter. If, for example, the value in a row selection is left blank, the selection is ignored and all rows are retained. On the other hand, if a grouping column in a tabulation is left blank, the tabulation is performed, but it is done with fewer (or no) grouping columns.

If an item is optional, you can make it Opt In or Opt OutOpt In means that the input will start out as blank; when set to Opt Out, the input shows the value that appears under Current Value. (For a required input, the input always shows the Current Value.)