AX2699

Choose Data Element command

Use the Choose Data Element command to select an item from a reference table and place it in the current cell. You can allow the user to navigate to any eligible table and select a data element, or you can specify a particular table and column as well as other limiting parameters.

Can be used in

Ribbon tabs
Task panes

When the Choose Data Element command is selected from the Command Library as the shortcut target, it displays as command://ChooseDataElement or command://ChooseDataElementCommandAdapter (legacy syntax).

Shortcut parameters

If you want the user to be able to select the data element from any reference table that they have access to, then leave the shortcut parameters blank. This is the same behavior as right-clicking a cell and selecting Axiom Wizards > Choose Data Element.

Alternatively, you can define shortcut parameters to specify the table and column from which the user should select a value. This works in a similar manner as the GetDataElement function.

Item	Description
Column	The table column from which the user will select values. You must use full Table.Column syntax.
Filter	Optional. A filter criteria statement to limit the list of values.
Display columns	Optional. Additional columns to display in the dialog. Separate multiple columns with commas. NOTE: If the specified column for the list of values is a key column, the designated description column will be automatically displayed if present—you do not need to list it separately. If other columns are listed, then the full grid view dialog will be used instead of the simple selection dialog.

Item

Description

Column

The table column from which the user will select values. You must use full Table.Column syntax.

Filter

Optional. A filter criteria statement to limit the list of values.

Display columns

Optional. Additional columns to display in the dialog. Separate multiple columns with commas.

NOTE: If the specified column for the list of values is a key column, the designated description column will be automatically displayed if present—you do not need to list it separately. If other columns are listed, then the full grid view dialog will be used instead of the simple selection dialog.

If you use the shortcut parameters, it is recommended to edit the display text for the task pane or ribbon tab item, to indicate the value that the user will be choosing (such as "Select an account"). By default, the display text is simply Choose Data Element.

Visibility

By default, items that use the Choose Data Element command are only visible if the active document is a spreadsheet document.

You can use the Show restricted items option in the task pane or the ribbon tab to force items that use this command to be visible at all times (but grayed out if unavailable).