search

levylabpitt / LV-Data

Collection of LabVIEW VIs to read and write lab data.
BSD 3-Clause "New" or "Revised" License
3 stars 1 forks source link

Read Trace #105

Closed ciozi137 closed 1 year ago

ciozi137 commented 1 year ago

update SELECT query to ignore points that are NaN:

image

SELECT time,%s FROM %s
WHERE %s IS NOT NULL
AND nullif(%s, 'NaN') IS NOT NULL
AND time BETWEEN '%s'::timestamp AND '%s'::timestamp
ORDER BY time %s
LIMIT %s
;