Home
Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
Application Development
<dynamic>
The <dynamic> element creates an environment in 1010data that maintains the state of system interactions and controls the running of queries.
Dynamic Variables
In order to use variables to store values that all your <widget>s can utilize, your variables must be declared in the opening <dynamic> tag of the <dynamic> element that contains the QuickApp.

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.
    - Dynamic Variables
      In order to use variables to store values that all your <widget>s can utilize, your variables must be declared in the opening <dynamic> tag of the <dynamic> element that contains the QuickApp.
  - <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.

Dynamic Variables

In order to use variables to store values that all your <widget>s can utilize, your variables must be declared in the opening <dynamic> tag of the <dynamic> element that contains the QuickApp.

A QuickApp is effectively a collection of <widget> elements and <layout> elements contained within a <dynamic> element. These elements work together to create a cohesive and useful experience for end-users who consume the QuickApp. For the QuickApp author, it is often necessary to modify a value with one <widget> and display the results in another. To do this, variables must be used.

In order to use variables to store values that all your <widget>s can utilize, your variables must be "visible" to all the <widget>s that need to use them. To accomplish this, all variables must be declared in the opening <dynamic> tag of the <dynamic> element that contains the QuickApp. Variables in the <dynamic> tag are declared much in the same way as they are in <block> statements. In other words, they appear in the opening <dynamic> tag as user-defined attributes, and then are referenced with a specific syntax. Here is the syntax for declaring variables in a <dynamic> tag:

<dynamic mode_="auto" var1="" var2="" var3="">
        [WIDGET]
</dynamic>

To reference a variable in a <widget>, the following syntax is used:

<dynamic mode_="auto" var1="" var2="" var3="">
       <widget class_="checkbox" value_="@var1"/>
</dynamic>

Keep in mind that a <widget> can also have user-defined variables. However, in order for all widgets to see a variable, it must be declared in the <dynamic> opening tag.