Action: Select

These are the input types for the various parameters associated with a Select action within a Quick Query.

Parameter: Column for criterion x

Input Type Description
Dropdown,Required The user is required to choose a column via a drop-down selection box.
Dropdown,Opt Out The user may choose a column via a drop-down selection box. The selection box is initially shown with a column selected, but the user may clear it. If the user clears it (i.e., chooses no column), the criterion is ignored.
Dropdown,Opt In The user may choose a column via a drop-down selection box. The selection box is initially shown with no column selected. If the user leaves it blank (i.e., chooses no column), the criterion is ignored.

Parameter: Relation for criterion x

Input Type Description
Dropdown,Required The user is required to choose a relationship (has the value(s), is greater than, etc.) via a drop-down selection box.
Dropdown,Opt Out The user may choose a relationship (has the value(s), is greater than, etc.) via a drop-down selection box. The selection box is initially shown with a relationship selected but the user may clear it. If the user clears it (i.e., chooses no relationship), the criterion is ignored.
Dropdown,Opt In The user may choose a relationship (has the value(s), is greater than, etc.) via a drop-down selection box. The selection box is initially shown with no relationship selected. If the user leaves it blank (i.e., chooses no relationship), the criterion is ignored.

Parameter: Value for criterion x

Input Type Description
Text,Required The user is required to type a value into a text field.
Text,Opt Out The user may type a value into a text field. The field is initially filled in. If the user clears it, the criterion is ignored.
Text,Opt In The user may type a value into a text field. The field is initially blank. If the user leaves it blank, the criterion is ignored.
Dropdown,Required The user is required to choose a value via a drop-down selection box. The choices in the selection box are not sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Dropdown,Strict,Required The user is required to choose a value via a drop-down selection box. The choices in the selection box are sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Dropdown,Opt Out The user may choose a value via a drop-down selection box. The selection box is initially shown with a value selected, but the user may clear it.  If the user clears it (i.e., chooses no value), the criterion is ignored. The choices in the selection box are not sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Dropdown,Strict,Opt Out The user may choose a value via a drop-down selection box. The selection box is initially shown with a value selected, but the user may clear it. If the user clears it (i.e., chooses no value), the criterion is ignored. The choices in the selection box are sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Dropdown,Opt In The user may choose a value via a drop-down selection box. The selection box is initially shown with no value selected. If the user leaves it blank (i.e., chooses no value), the criterion is ignored. The choices in the selection box are not sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Dropdown,Strict,Opt In The user may choose a value via a drop-down selection box. The selection box is initially shown with no value selected. If the user leaves it blank (i.e., chooses no value), the criterion is ignored. The choices in the selection box are sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Multiple,Required The user is required to choose one or more values via a selection box. The choices in the selection box are not sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Multiple,Strict,Required The user is required to choose one or more values via a selection box. The choices in the selection box are sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Multiple,Opt Out The user may choose one or more values via a selection box. The selection box is initially shown with one or more values selected, but the user may clear them. If no value is selected, the criterion is ignored. The choices in the selection box are not sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Multiple,Strict,Opt Out The user may choose one or more values via a selection box. The selection box is initially shown with one or more values selected, but the user may clear them. If no value is selected, the criterion is ignored. The choices in the selection box are sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Multiple,Opt In The user may choose one or more values via a selection box. The selection box is initially shown with no values selected. If the user leaves it blank (i.e., chooses no value), the criterion is ignored. The choices in the selection box are not sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)
Multiple,Strict,Opt In The user may choose one or more values via a selection box. The selection box is initially shown with no values selected. If the user leaves it blank (i.e., chooses no value), the criterion is ignored. The choices in the selection box are sensitive to previous selections. (If there are more than 1000 choices, a text field is used instead of a selection box.)

Parameter: Lower value for criterion x

Input Type Description
Text,Required The user is required to type a value into a text field.
Text,Opt Out The user may type a value into a text field. The field is initially filled in. If the user clears it, the criterion is ignored.
Text,Opt In The user may type a value into a text field. The field is initially blank. If the user leaves it blank, the criterion is ignored.

Parameter: Upper value for criterion x

Input Type Description
Text,Required The user is required to type a value into a text field.
Text,Opt Out The user may type a value into a text field. The field is initially filled in. If the user clears it, the criterion is ignored.
Text,Opt In The user may type a value into a text field. The field is initially blank. If the user leaves it blank, the criterion is ignored.

Parameter: Selection expression

Input Type Description
Text,Required The user is required to type a selection expression into a text field.
Text,Opt Out The user may type a selection expression into a text field. The field is initially filled in. If the user clears it, no selection is done.
Text,Opt In The user may type a selection expression into a text field. The field is initially blank. If the user leaves it blank, no selection is done.