Home
Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
Application Development
<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.
action_="getdata"
<do action_="getdata"> runs the given 1010data query and returns the results.

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.
    - action_="allocctrl"
      <do action_="allocctrl"> changes the subprocess allocation strategy used by MDB. (Available as of version 10.25)
    - action_="api"
      <do action_="api"> sends a 1010data API transaction.
    - action_="cacheclear"
      <do action_="cacheclear"> clears the cache after running the associated 1010data query, if specified. If no query is specified, this action simply clears the cache. (Available as of version 10.15)
    - action_="cachectrl"
      <do action_="cachectrl"> controls cache behavior and inspects cache statistics. (Available as of version 10.25)
    - action_="clearcache"
      <do action_="clearcache"> clears the cache before running the associated 1010data query, if specified. If no query is specified, this action simply clears the cache.
    - action_="combine_tabs"
      <do action_="combine_tabs"> combines two or more tables into a new table. (Available as of version 19.48)
    - action_="compcheck"
      <do action_="compcheck"> performs a compatibility check on a given 1010data query. (Available as of version 10.27)
    - action_="files"
      <do action_="files"> retrieves a list of files in a valid FTP directory. (Available as of version 10.25)
    - action_="getdata"
      <do action_="getdata"> runs the given 1010data query and returns the results.
    - action_="getfilter"
      <do action_="getfilter"> gets the filter, if one exists, for a specified table. (Available as of version 10.23)
    - action_="getquery"
      <do action_="getquery"> places the Macro Language code of a given query into an XML variable and/or as text into a dynamic variable. (Available as of version 10.23)
    - action_="hashdel"
      <do action_="hashdel"> removes a key/value association from the user-specific private store. (Available as of version 10.23)
    - action_="hashget"
      <do action_="hashget"> retrieves the value associated with a given key from the user-specific private store. (Available as of version 10.23)
    - action_="hashput"
      <do action_="hashput"> saves a key/value association to the user-specific private store. (Available as of version 10.23)
    - action_="importtable"
      <do action_="importtable"> imports an iceberg-formatted table or a set of parquet files, and returns basic metadata statistics. (Available as of version 20.05)
    - action_="limits"
      <do action_="limits"> sets or inspects system settings. (Available as of version 10.25)
    - action_="log"
      <do action_="log"> sends a message to the 1010data system logger. (Available as of version 10.23)
    - action_="password"
      <do action_="password"> changes a user's 1010data password. (Available as of version 10.29)
    - action_="qqtoqa"
      <do action_="qqtoqa"> loads a legacy Quick Query and constructs a QuickApp with the same functionality. (Available as of version 10.34)
    - action_="query"
      <do action_="query"> runs the given 1010data query even if no data is retrieved or if the underlying block code has not changed. (Available as of version 10.15)
    - action_="savefile"
      <do action_="savefile"> saves the results of a 1010data query as a delimited file on the user's FTP account. (Available as of version 10.25)
    - action_="saveqa"
      <do action_="saveqa"> commits changes to the ops of a rendered and potentially modified QuickApp and saves them as a new QuickApp. (Available as of version 10.15)
    - action_="savequery"
      <do action_="savequery"> expands a given 1010data query and saves the ops resulting from the expansion as a query. (Available as of version 10.23)
    - action_="savetable"
      <do action_="savetable"> executes a given 1010data query and saves the results as a table. (Available as of version 10.23)
    - action_="setfilter"
      <do action_="setfilter"> sets the filter on a specified table. (Available as of version 10.23)
    - action_="sleep"
      <do action_="sleep"> sleeps for a specified period of time. (Available as of version 16.29)
    - action_="syskill"
      <do action_="syskill"> kills active user sessions. (Available as of prod-9)
    - action_="userprofile"
      <do action_="userprofile"> sets or retrieves user profile data and preferences. (Available as of version 10.29)
  - <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.

`action_="getdata"`

<do action_="getdata"> runs the given 1010data query and returns the results.

Syntax

<dynamic>
    <do action_="getdata" tablevalue_="@[TABLE_VALUE_VARIABLE]">
       [1010data_QUERY]
    </do>
</dynamic>

Attributes for `action_="getdata"`

tablevalue_

The results of the <do> clause are stored as a table value in the dynamic variable associated with this attribute.

The variable associated with this attribute can be indexed using the following syntax:

@foo.bar provides a list consisting of the values in the column bar
@foo.17 provides a dictionary consisting of the row 17
@foo._cols provides a list of column names
@foo._rows provides the number of rows

The variable must be declared in the opening <dynamic> tag of the QuickApp (e.g., <dynamic var_name="">).

action_="getdata"

Syntax

Attributes for action_="getdata"

`action_="getdata"`

Attributes for `action_="getdata"`