Ok, we have this data from influx. Temperature over the last 30 minutes [{"time":"2020-05-18T19:09:53.000Z","Temperatur":24.1},{"time":"2020-05-18T19:09:58.000Z","Temperatur":24},{"time":"2020-05-18T19:12:48.000Z","Temperatur":23.9},{"time":"2020-05-18T19:13:27.000Z","Temperatur":24},{"time":"2020-…

I got the following hint from the jsonata guru's. $.payload^(Temperatur)[[0, -1]] It orders them by temperature and gets the first and last element, nice.

Topic		Replies	Views
Node-red-contrib-influxdb function to pass a specific time query General database	12	3229	1 December 2021
Working with Influxdb 2.x timestamp General	29	1681	8 August 2022
Retrieve Data from sqlite database based on the input time from date picker and moment nodes Dashboard	7	939	17 February 2022
Possible issue with mySQL date column and JSONATA $spread() function General database	12	730	26 January 2022
Node Red Custom Date Time insert into influx FLUX issue General	18	452	26 March 2023

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

JSONata: Get max and minimum temperature with timestamp

Related topics