Time Bounded History Export via MQTT in the Tridium Jace

It is possible to export export histories within a certain time period. The time range is added to the Query Pattern slot in the relativeHistorySchema under Queries>{Q} historyQuery.

The basic history export BQL query is: %baseHistoryOrd%?|bql:select timestamp, value

This can be amended with a defined period: %baseHistoryOrd%?period=X|bql:select timestamp, value

Where the following options can be used in place of X:

today

yesterday

last24hours

weekToDate

lastWeek

last7Days

monthToDate

lastMonth

yearToDate

lastYear

For example %baseHistoryOrd%?period=monthToDate|bql:select timestamp, value would export histories with timestamp in the current month.

A time range can also be configured.

timeRange;start=yyyy-mm-ddThh:mm:ss.mmm[+/-]hh:mm;end=yyyy-mm-ddThh:mm:ss.mmm[+/-]hh:mm

For example, exporting a history between 20:00:00 18/05/2022 and 09:00:00 19/05/2022, where the Jace local time is +10hrs from UTC would be:

%baseHistoryOrd%?timeRange;start=2022-05-18T20:00:00.000+10:00;end=2022-05-19T09:00:00.000+10:00|bql:select timestamp, value