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_="hashget"
<do action_="hashget"> retrieves the value associated with a given key from the user-specific private store. (Available as of version 10.23)

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 file in the user's FTP account or remote clous storage (ex. AWS S3, Azure Blob). (Available as of version 20)
    - 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_="hashget"`

<do action_="hashget"> retrieves the value associated with a given key from the user-specific private store. (Available as of version 10.23)

Syntax

<dynamic all_values="{pkg(;)}" var="">
    <do action_="hashget" 
     key_="[KEY]" value_="@var"
     pkgvalue_="@all_values" strict_="0|1"/>
</dynamic>

Attributes for `action_="hashget"`

key_

Specifies the key whose value is to be retrieved from the store.

value_

The dynamic variable associated with the value_ attribute is set to a package containing information about the key specified by the key_ attribute.

The variable must be declared as a package in the opening <dynamic> tag of the QuickApp (e.g., <dynamic var_name="{pkg(;)}">).

pkgvalue_

The dynamic variable associated with the pkgvalue_ attribute is set to a package containing information about the user's entire store (key_ and value_ are optional).

The variable must be declared as a package in the opening <dynamic> tag of the QuickApp (e.g., <dynamic var_name="{pkg(;)}">).

strict_

Determines whether or not to display an error if the given key is not present in the store. Accepts a 1 or 0.

When strict_="1", an error is thrown if the specified key is not in the store.

When strict_="0", the variable specified by the value_ attribute is set to the empty string if the specified key is not in the store.

The default is 0.

Example: Get the list of keys currently stored

<dynamic my_hash="{pkg(;)}" names="">
  <do action_="hashget" pkgvalue_="@my_hash"/>
  <widget class_="text" text_="{pkg_names(@my_hash)}"/>
</dynamic>