Appendix E: History Schema Configuration in the Tridium Jace

In the Jace a JSON history export is configured similar to a routine interval upload, but with some differences in schema function block configuration.

From kitControl palette > ControlPalette > Trigger, drag an interval trigger onto the wire sheet.

Set trigger mode to Manual.

For the Json Schema, the easiest way is to go to jsonToolkit palette > Examples > Schemas and drag a RelativeHistorySchema onto the wire sheet.

Open up the new RelativeHistorySchema and you see there’s a historyQuery within Queries.

Configure the Config fields as follows:

Config Slot	Requirement/ Slot Contents	Notes
Name Casing Rule	Camel
Name Spacing Rule	Remove
Date Format Pattern	yyyy-MM-dd'T'HH:mm:ss.SSSXXX	Don’t forget the ‘T’
Numeric Precision	4	Set to 3 if preferred (site and point dependent)
Use Escape Characters	false
Min Write Time	0
Max Write Time	0
Write On Start	false
Write On Enabled	false
Update Strategy	On Demand Only	Interval update rather than Change Of Value update

The other fields in config can be left as default.

Enter the following text into Queries: {Q} historyQuery: Query Pattern

%baseHistoryOrd%?|bql:select timestamp, value

Enter the following text into Base Query: Base Query

station:|slot:/|bql:select * from history:HistoryConfig

Configure the { } root slots as follows. The Status, facets and tags fields are optional.