Inline data

The Widget Builder allows you to provide data within an editable grid, which can be converted to an inline table in the query for the current widget.

You can manually enter data into the editable grid, or you can import the results from the current query (by clicking Import) and then modify the data in the editable grid. If you want to add or remove rows or columns from the editable grid, right-click and select the desired action from the context menu:

When you are satisfied with the contents of the editable grid and want the data to be used in the query associated with the widget, click Use. The contents of the editable grid will be converted into an inline table that is used by the widget. (See Table Tree for details about the format of the inline table.)
Note: Any query code previously in the Query XML tab for this widget will be overwritten by the inline table when Use is clicked.

For instance, after clicking Use in the Inline data tab in the above example, the Query XML tab will contain Macro Language code that looks something like the following:

After the inline table has been successfully converted, the Macro Language code associated with it can be modified in the Query XML tab.

For example, in the above example, if you wanted to sort the contents of the inline table, you could add a <sort> operation after the table in the Macro Language code in the Query XML tab:

You can then click the Data preview tab to see that the items have been sorted in ascending order: