Function node to filter 2 values out

General
13

Completely agree with this -- somewhere there is probably a SQL select statement that is returning everything, instead of just those fields that you want to display. Narrowing down your query, and grouping the 1000's of data points into chunks of time, will greatly improve the performance of the UI chart.

But, for future reference, I would use a JSONata expression to remove those properties from your raw data (assuming you cannot change the raw data that is returned). Here is one way to use a change node to remove those *_qc properties from the entire array of objects:

image
image690×624 27.4 KB

Here are a couple expressions I can think of to return just the fields you need:

  1. "sift" each object, keeping only properties that do not end with _qc
payload.$sift(function($val,$key) {
    $not($key.$match(/.*_qc/))
})
  1. modify each object in-place, deleting any properties that end with _qc
payload ~> | $ | {}, $keys($)~>$filter(/.*_qc/) |
  1. build a new array of objects, using only selected properties from each object
payload.{
    "T_Zone_2_SOLL_Temperatur": T_Zone_2_SOLL_Temperatur,
    "T_Zone_2_IST_Temperatur": T_Zone_2_IST_Temperatur,
    "_time": _time
}