How can i specify the time range in oracle query

  • What Grafana version and what operating system are you using?
    UnixOS, Grafana 8.5.2.7

  • What are you trying to achieve?
    I have to perform a query to get data from am oracle table with time_range, say from last 6 hour

  • How are you trying to achieve it?
    I read the Global variables | Grafana documentation

  • What happened?

I could not figure out how to use the $__timeFilter in my query

  • What did you expect to happen?
    To get the rows returned from the time range

  • Can you copy/paste the configuration(s) that you are having problems with?
    select VALUE

from NAMENODE_RPC_HEALTH

where $__timeFilter

and METRIC_NAME = ‘rpc_num_open_connections’ and CLUSTER_NAME = UPPER(‘${Cluster}’) and REGION = UPPER(‘${Region}’)

and SDLC = UPPER(‘${SDLC}’)

and ACTIVE_STATUS = ‘ACTIVE’ FETCH FIRST ROW ONLY

I want the timeFilter in the range of last 6 hours

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

db query error: ORA-00911: invalid character