AX1473

Execute Data Lookups command

Use the Execute Data Lookups command to trigger manual processing of data lookup queries. This command provides a way to process data lookups "on demand," after the file has already been opened.

Can be used in

Axiom forms
Ribbon tabs
Task panes

When the ExecuteDataLookups command is selected from the Command Library as the shortcut target, it displays as command://ExecuteDataLookups or command://ExecuteDataLookupsCommandAdapter (legacy syntax).

Shortcut parameters

This command uses the following shortcut parameters:

Parameter Description

Data Lookups to Execute

Parameter	Description
Data Lookups to Execute	Specifies one or more data lookup queries to run when the command is executed, by listing the names of the DataLookup data sources. Separate multiple data source names with commas. The list of data source names can be qualified with sheet names (such as `Sheet1!Data`) or unqualified (just `Data`). If qualified, then Axiom Software will only scan the listed sheets for the data sources. If unqualified, then Axiom Software must scan all sheets for the data sources, which can impact performance. All items in the list must be either qualified or unqualified. Mixing qualified and unqualified names will result in an error when the data sources are executed. To run unnamed DataLookup data sources on open, use the keyword `[unnamed]` (either with a sheet name, or without to scan all sheets). The keyword can be used by itself or as part of the comma-separated list of names.
Processing Step	Specifies when the command will be executed during the form update process. This option only applies when using the command in an Axiom form. By default, this is set to Form - After Updating Values, which means that the command will be performed on the form source file, after updated values have been submitted back to the source file. If desired, you can specify a different processing step for the command. For more information, see Timing of command execution and Axiom form update process.

Specifies one or more data lookup queries to run when the command is executed, by listing the names of the DataLookup data sources. Separate multiple data source names with commas.

The list of data source names can be qualified with sheet names (such as Sheet1!Data) or unqualified (just Data). If qualified, then Axiom Software will only scan the listed sheets for the data sources. If unqualified, then Axiom Software must scan all sheets for the data sources, which can impact performance. All items in the list must be either qualified or unqualified. Mixing qualified and unqualified names will result in an error when the data sources are executed.

To run unnamed DataLookup data sources on open, use the keyword [unnamed] (either with a sheet name, or without to scan all sheets). The keyword can be used by itself or as part of the comma-separated list of names.

Processing Step

Specifies when the command will be executed during the form update process. This option only applies when using the command in an Axiom form.

By default, this is set to Form - After Updating Values, which means that the command will be performed on the form source file, after updated values have been submitted back to the source file.

If desired, you can specify a different processing step for the command. For more information, see Timing of command execution and Axiom form update process.

Visibility

In task panes and ribbon tabs, items that use this command are always visible and active, regardless of whether the current file has any data lookup queries.

In Axiom forms, the command used does not impact whether the button is visible or enabled.

In both environments, executing the command does not provide any user feedback as to whether any data lookups were run.