AX1067

Choose Value dialog

The Choose Value dialog allows users to select a value from a table when using the following features:

  • GetDataElement function
  • Refresh variables (when the variable is Grid)
  • Calc method variables (when the variable is Grid)

This dialog uses either the full Axiom grid format or a "simple view" format depending on the information shown in the dialog. If only one column is shown (including descriptions, if applicable), then the simple view is used. If multiple columns are shown, then the full grid view is used.

Simple view example

Full grid view example

If multiple columns are shown, users can use any of the normal Axiom grid features to sort and filter the list.

In both cases, users can type into the filter box at the top of the dialog to search for values in the list. All visible columns are included in the search. By default, the filter box uses Includes matching, which means that it will match any value in the list that includes the value in the filter box. For simple view dialogs only, the user can switch this matching behavior to Starts With or Ends With if desired.

NOTE: The system configuration setting DefaultFilterType specifies the default filtering behavior for the filter box. By default, this is set to Includes.

When using a Grid refresh variable with multi-select enabled, both dialogs include check boxes to select multiple items, as well as the ability to select all and clear all.

Dialog limits

The Choose Value dialog has different behavior in limiting the values shown in the dialog, depending on whether the "simple view" or "full grid view" is used.

  • Simple View: This view is limited to displaying the first 5,000 records returned by the query. However, when using the filter box to find a value, all records returned by the query can be found.
  • Full Grid View: By default, this view is limited to displaying the first 1,000 records returned by the query. However, when using the filter box to find a value, all records returned by the query can be found. If necessary, this limit can be changed by using the system configuration setting MaxChooseValueRows.
See also