UPDATE $__timeFilter variable

[gerryjouaud]

Hi everyone, hope you’re doing well.

-I’m on debian and using v10.0 Grafana

• I want to update the value of the date Picker selected by the user for one panel to get on my dashboard a panel with the previous informations of a working period.
  For example, if this date is selected :
  
  I want to search in my database for this date with a -8 hour interval.

-I tried to modify directly the value of the timeFilter variable with SQL but i doesn’t work:
Unmodified timeFilter =>

And i try to achieve this =>

Thanks for helping

[infofcc3]

try this

SELECT
  employee_name,
  Time_Stamp,
  activity
FROM working_logs
WHERE Time_Stamp BETWEEN
  TO_TIMESTAMP($__from / 1000) + INTERVAL '8 hour'
  AND
  TO_TIMESTAMP($__to / 1000) + INTERVAL '8 hour'

[infofcc3]

For past 8 hour

[gerryjouaud]

Thank you so much for this MySQL solution.
I have founded another solution with the QueryOptions, setting the parameter ‘Time shift’

Thank you guys