Home
Macro Language Elements
The section contains detailed specifications for all 1010data Macro Language elements.
Application Development
<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.
<pdf>
The <pdf> element provides the ability to customize the appearance of the output when rendering a QuickApp to a PDF. (Available as of prod-9)

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.
    - <web>
      The <web> element provides the ability to customize the appearance of the output when rendering a QuickApp to the web. (Available as of prod-9)
    - <xlsx>
      The <xlsx> element provides the ability to customize the appearance of output when rendering to a Microsoft Excel workbook. (Available as of prod-9)
    - <data>
      The <data> element provides the ability to customize the appearance of the output when rendering the data from grid widgets to a flat text file. (Available as of prod-9)
    - <pdf>
      The <pdf> element provides the ability to customize the appearance of the output when rendering a QuickApp to a PDF. (Available as of prod-9)
    - <static>
      The <static> element provides the ability to customize the appearance of the output when rendering a QuickApp as a static HTML page. (Available as of version 11.15)
  - <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.

`<pdf>`

The <pdf> element provides the ability to customize the appearance of the output when rendering a QuickApp to a PDF. (Available as of prod-9)

Description

It is possible to specify options for output rendering at both the <render> level and the <widget> level. When specifying configuration options at the <render> level, specify attributes directly to the <pdf> element. To specify configuration options at the <widget> level, the attributes must be prefixed with pdf_.

Syntax

<dynamic>
  <render>
    <pdf [ATTR1_NAME]="[VALUE]"
          [ATTR2_NAME]="[VALUE]"
           ... />    
  </render>
</dynamic>

Alternate syntax

<dynamic>
    <widget class_="grid" 
            pdf_[ATTR1_NAME]="[VALUE]"
            pdf_[ATTR2_NAME]="[VALUE]"
            ... />
</dynamic>

Attributes

orientation_

Specifies the orientation of the resultant PDF.

Valid values are:

portrait
landscape

The default is portrait.

firstpageheader_

Controls whether a header is added to the first page. Accepts 1 or 0.

The default is 0.

fontembedding_

Specifies whether to embed all fonts or to not embed any fonts at all. Accepts all or none.

The default behavior is some font embedding, however standard fonts that PDF readers are expect to have are not embedded, yielding smaller file sizes. This attribute overrides the default behavior.

Valid values are:

all: Install all fonts, including standard fonts that PDF readers are expected to have. This will result in a larger file size.
none: Do not install any fonts. This will result in smaller files, but font substitutions on some platforms may occur.

Example: Specifying attributes at the `<render>` level

<dynamic>
  <render>
    <pdf orientation_="landscape"/>
  </render>
  <widget class_="button" type_="render" target_="pdf"/>
  <widget class_="grid" base_="pub.demo.retail.item"/>
</dynamic>

Example: Specifying attributes at the `<widget>` level

<dynamic>
  <widget class_="button" type_="render" target_="pdf"/>
  <widget class_="grid" base_="pub.demo.retail.item" 
   pdf_orientation_="landscape"/>
</dynamic>