A field containing your JSON text that represents your data object
Eg,"GLOBALS::example_json_pivot"
defaultRow
A key from your JSON to use as the initial PivotTable row(optional)
Eg,"Gender"
defaultColumn
A key from your JSON to use as the initial PivotTable column(optional)
“g,"Party"
defaultRenderer
The default rendering form for your pivot table(optional)
Eg,"Horizontal Bar Chart"
Example
PivotTable (
"GLOBALS::example_json_pivot" ;
"Gender" ;
"Party" ;
"Horizontal Bar Chart"
)
In order to generate your JSON string, the easiest way is to use the in-built FM JSON functions.
Relationship
This BlackBox is designed for a single record, rather than a found set. So your table occurrence should have a relationship from the current context that matches to only one record.
Reactor knows nothing about your current found set.
If your current context is the record containing the JSON you wish to use as your dataset, create a self-relationship, and use that as the BlackBox parameter(s):
User-uploaded image: image.png
Style Customisations
You can customise the CSS of the portal by using Reactor Core to edit the following CSS document:
PivotTable ( json { ; defaultRow ; defaultColumn ; defaultRenderer } )PivotTable ( "GLOBALS::example_json_pivot" ; "Gender" ; "Party" ; "Horizontal Bar Chart")