Home
Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
Application Development

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.

Application Development

QuickApps is an extension of the 1010data Macro Language designed for building custom interfaces for web-based reports and applications. For the first time, 1010data users have the ability to not only perform ad hoc analytics on their data, but to build entire applications for broadening and sharing such analyses. QuickApps introduces several new Macro Language elements to the language. These new elements are more oriented toward creating common on-screen, HTML objects than performing data analysis. However, they also work with the basic operations of the Macro Language, as well as <block> elements, to control query execution and program flow.

Learning to master the QuickApps tools documented in this reference will provide a way to quickly generate fast, interactive, visually cohesive reports and applications. In fact, we think it's pretty RAD!

Note: After submitting a query that contains a <dynamic> element (either explicitly or via a block), a table will be returned. In order to view the results as a QuickApp, click View > Show QuickApp... from the menu bar of the 1010data web interface.