Query XML

The Query XML tab provides you with an XML editor to directly enter the Macro Language code for the query associated with the widget.

The Query XML tab also has a folder browser that you can use to select the Base table path for the query.

For example, a sorter widget uses the results of its associated query to populate the contents of its sorted list. It expects either a one-column table consisting of the values it will use to populate the list, or a two-column table that contains values in the first column and their corresponding labels in the second column.

The Macro Language code in the following example produces a two-column table with unique SKU values in the first column and the corresponding item descriptions (which it got from linking in the product master table) in the second column.

Note: You can see an example of the results from this query in the Data preview tab.