Suggestion about tracking orders in SQL

[E1cid]

You could simplify the JSONata to

$append($flowContext("array")[$ != $$.payload], [$$.payload])

this wiill return the context array minus the incoming payload, then append the new payload to the end of the array, this also works well for arrays of objects.

this thread has some good examples of searching and appending to arrays with JSONata

UI with selectable AIS ship target list

Hello, I am trying to create a Dashboard, where I can pick a ship/target from a drop-down list and display it's data... So far I set up a tcp:port where I receive AIS-NMEA data constantly. The "ais"-node transforms the data into readable json format (Objects?). The AIS data is sent every few seconds from several vessels (each has a specific time slot). If I want to select the data from just one special ship, l need to filter the incoming data, e.g. by ships name (or "mmsi")... ... additionall…