Home
Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
Application Development
<loop>
<loop> is a special operation that allows one query to iteratively reference the data from each row in the results of another query.
<inner>
The <inner> element contains a Macro Language query that uses the results from the query in the <outer> element of a <loop> construct.

Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
- Data Transformation
  Data transformation operations use functions and expressions to functionally alter tabular data. These operations take 0, 1, or 2 tables as input and produce a single table as a result.
- Blocks
  Blocks allow users to reuse sections of Macro Language code and to parameterize values in that code for greater flexibility and power.
- Application Development
  - <dynamic>
    The <dynamic> element creates an environment in 1010data that maintains the state of system interactions and controls the running of queries.
  - <render>
    The <render> element provides the ability to configure certain QuickApp widgets when rendered to available output targets. A single <render> element contains one or more elements that specify output targets and settings for the final output.
  - <layout>
    The <layout> element is a nestable pseudo-operation that can be used to organize <widget> elements and other <layout> elements.
  - <widget>
    <widget> is used to define all visual components of a QuickApp, including drop-downs, text boxes, tables, and calendars. The form a widget takes is controlled by the class_ attribute.
  - <do>
    A <do> clause within a <dynamic> provides the ability for <dynamic> variables to be updated when some variable within the scope of the <dynamic> is changed.
  - <do action_="sql">
    <do action_="sql"> provides a programmatic API to the SQL metadata store. (Available as of version 17.29)
  - <loop>
    <loop> is a special operation that allows one query to iteratively reference the data from each row in the results of another query.
    - <outer>
      The <outer> element contains a Macro Language query that generates a result set that can be used by the query in the <inner> element of a <loop> construct.
    - <inner>
      The <inner> element contains a Macro Language query that uses the results from the query in the <outer> element of a <loop> construct.
    - <preamble>
      When using <loop mode_="concat">, the query code for each iteration of the <inner> clause is concatenated into a single query. The contents of a <preamble> clause are prepended to the concatenated code before the query is executed.

`<inner>`

The <inner> element contains a Macro Language query that uses the results from the query in the <outer> element of a <loop> construct.

Syntax

<loop ...>
  <outer>
    [1010data_QUERY]
  </outer>
  <inner>
    [1010data_QUERY]
  </inner>
</loop>

Attributes

base_: Specifies the name of the base table for the query specified by the <inner> element. This is analogous to specifying a base table via a <base> operation in the query.
Note: Specifying a base_ attribute in an <inner> element is not very useful for <loop mode_="concat">. Include the base_ attribute in a <preamble> instead. For more information, see <preamble>.