Top-Level List Loop

In case the JSON data you want to display is a list like the following:

[
  {
    "id": 1,
    "name": "Mario Speedwagon",
    "username": "mario"
  },
  {
    "id": 2,
    "name": "Anna Sthesia",
    "username": "anna"
  }
]
JSON

This can happen when you filter data returning a list. You can access the list in the template by using the following syntax. {{#.}} to start the loop and {{/.}} to close the loop.

<table class="aui aui-table-list">        
    <thead>
        <th>ID</th>
        <th>Name</th>
    </thead>
    <tbody>
    {{#.}}
        <tr>
            <td>{{ id }}<td>
            <td>{{ name }}<td>
        </tr>            
    {{/.}}
    </tbody>
</table>
HTML

Number Formatting

You can use helper functions for better formatting of numbers.

The following examples are run on this JSON:

{
    "number1": 1.5,    
    "number2": 1000.457
}
CODE

Examples

{{ FormatCurrency number1 }}
-> $1.50

{{ FormatNumber number1 'N0' }}
-> 2

{{ FormatNumber number1 'N1' }}
-> 1.5

{{ FormatNumber number1 'N2' }}
-> 1.50
CODE

The default setting for the number formatting is en-US. If you need other formatting options, you can easily add another Format Culture:

{{ FormatCurrencyCulture number1 'de-DE'}}
-> 1,50 €
{{ FormatNumberCulture number2 'N2''de-DE' }}
-> 1.000,46    
CODE

Date & Time Formatting

Helper functions can help you with basic date and time formatting:

{
    "time": "2020-09-01T22:05:45.488+02:00"
}
CODE

Examples

{{ FormatDate time 'g''en-Us'}}
-> "9/1/2020 10:05 PM"

{{ OffsetTimezoneThenFormatDate time '+8''g''en-AU'}}
-> "2/9/2020 4:05 am"
CODE

The g in the examples is a format type that can be changed to the following formats. This variable varies depending on the Format Culture.

* d :08/17/2000
* D :Thursday, August 17, 2000
* f :Thursday, August 17, 2000 16:32
* F :Thursday, August 17, 2000 16:32:32
* g :08/17/2000 16:32
* G :08/17/2000 16:32:32
* m :August 17
* r :Thu, 17 Aug 2000 23:32:32 GMT
* s :2000-08-17T16:32:32
* t :16:32
* T :16:32:32
* u :2000-08-17 23:32:32Z
* U :Thursday, August 17, 2000 23:32:32
* y :August, 2000
CODE

IF / ELSE Example

If you want to display a coloured badge depending on whether a value is true or false, consider the following JSON data…

[
  { 
    "isActive": false,
    "company": "POWERNET"
  },
  {   
    "isActive": true,
    "company": "EXIAND"
  },
  {   
    "isActive": false,
    "company": "KYAGURU"
  },
  {
    "isActive": true,
    "company": "OATFARM"
  },
  {
    "isActive": true,
    "company": "VIAGRAND"
  }
]
CODE

…in combination with the following template (with {{#isActive}} being the IF part and {{^isActive}} referring to the ELSE part).


<table class="aui">
{{#.}}
    <tr>        
        <td>{{company}}</td>
        <td>
            {{#isActive}}
                <span class="aui-lozenge aui-lozenge-removed">Inactive</span>
            {{/isActive}}
            {{^isActive}}
                <span class="aui-lozenge aui-lozenge-success">Active</span>
            {{/isActive}}
        </td>
    </tr>
{{/.}}
</table>
CODE

The result should look like this:

In case you need to compare the value of your data source, you can use the following helper function to achieve a similar result:


<table class="aui">
{{#.}}
    <tr>        
        <td>{{company}}</td>
        <td>
            <span class="aui-lozenge aui-lozenge-{{ RenderOnMatch isActive 'true''success''removed'}}">
              {{ RenderOnMatch isActive 'true''Active''Inactive'}}
            </span>
        </td>
    </tr>
{{/.}}
</table>
CODE

RenderOnMatch Example Explained

{{ RenderOnMatch field 'compare''equal''notequal'}}
CODE

This helper function compares the value compare with the value of the field and renders equal if they are are identical and notequal if they differ.

SearchReplace

In case you have a text that contains line breaks like \n or \r\n and want to display those line breaks in HTML you can use the following syntax:

{{ SearchReplace field '\n''<br>' }}
CODE

or

{{ SearchReplace field '\r\n''<br>' }}
CODE

Arithmetics

There are also helper functions to do basic arithmetics in combination with formatting of the result.

The following examples are run on this JSON

{
    "number1": 6,    
    "number2": 3
}
CODE

Examples

You can add, subtract, divide and multiple decimal values.

{{ AddThenFormat number1 number2 'N1' }}
-> 9.0

{{ SubThenFormat number1 number2 'N1' }}
-> 3.0

{{ DivThenFormat number1 number2 'P1' }}
-> 50.0%

{{ MulThenFormat number2 number1 'N1' }}
-> 18.0
CODE

If you need different culture formats you can customize them as well. The default setting for number formatting is en-US.

{{ AddThenFormatCulture number1 number2 'N1''de-DE' }}
-> 9,0

{{ SubThenFormatCulture number1 number2 'N1''de-DE' }}
-> 3,0

{{ DivThenFormatCulture number1 number2 'P2''de-DE' }}
-> 50,00%

{{ MulThenFormatCulture number2 number1 'N1''de-DE' }}
-> 18,0
CODE

Access Array By Index

The following examples are run on this JSON:

{
  "result":[
    { "name" : "anybody"},
    { "name" : "nobody"}
  ]
}
JSON

Examples

{{#result.0}} {{ name }} {{/result.0}}
-> anybody
{{#result.1}} {{ name }} {{/result.1}}
-> nobody

{{ AccessArrayByIndex 'result''0''name' }}
-> anybody
{{ AccessArrayByIndex 'result''1''name' }}
-> nobody
CODE

The following examples are run on this JSON:

[
  { "name" : "anybody"},
  { "name" : "nobody"}
]
JSON

Examples

{{ AccessArrayByIndex '.''0''name' }}
-> anybody
{{ AccessArrayByIndex '.''1''name' }}
-> nobody
CODE

Javascript

Due to security reasons, we currently don’t allow any custom Javascript logic within templates. However, you can still work with AUI elements that don’t need extra scripting, like the expander.