Hi, i have this query to show all record from the beginning but seem doesnt work because the automatic $__timeFilter still working in the back, and just show what is selected in the time range.
There is a way to avoid this automatic $__timeFilter() ?.
SELECT
UNIX_TIMESTAMP(ArrivalTime) as time_sec,
ENERGIA_ACTIVA_IMPORTADA_T1 as ‘Energía Activa Importada T1’,
ENERGIA_REACTIVA_IMPORTADA_T1 as ‘Energía Reactiva Importada T1’
FROM GSV.Equipo_1
WHERE ArrivalTime between ‘2019-12-10 00:00:00’ and now()
AND ENERGIA_ACTIVA_IMPORTADA_T1 is not NULL
AND ENERGIA_REACTIVA_IMPORTADA_T1 is not NULL
ORDER BY ArrivalTime ASC