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