|Widget Builder | Query ||
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.