On this page
Overview
This page shows how to use Augments for field manipulation or calculations when using the JSON Table macro, which is part of the Advanced Tables for Confluence add-on. In this example, we use Groovy scripting to do field modificationculation based on the field data. This is just a simple example of the technique.
Scripting is expensive, so make sure you surround the json-table macro with the Cache Macro and/or the Future Macro to minimize response time for the page.
Reference: Using Augments with JSON Table.
Macro Browser Input
Select this Macro
| Macro Name | JSON Table |
| Macro Syntax | {json-table} |
Define these Parameters/Values
| Body | [{a: 1495020217, b: 1495020217.0}] |
| Output format | wiki |
| Augments to data row values | , "{groovy}def x='%1%'; print x.substring(0,10){groovy}" |
| Column types | MX~YYYY-MM-DD, MX~YYYY-MM-DD |
Example Result
| A | B |
|---|---|
| 2017-05-17 | 2017-05-17 |
Other Examples
Visit our full list of product examples for additional inspiration!
