Scripted dashboards - left start-time and left end-time

[calvernaz]

Hi,

I'm having issues using the scripted dashboard, particularly the start and end time for the left and right runs.

My understanding is after picking the left run (for example) the values for the variables start_time_left and end_time_left should be timestamps.

Now the variables comes from the following query:

SELECT * FROM jmeter WHERE application =~ /$tag_left/ ORDER BY time asc LIMIT 1

That is not returning a timestamp in my case. I'm using influxdb-timeshift-proxy and that's the datasource for the query above.

The URL looks like:

&var-end_time_right=load-test.jmx%20@%20106%20@%20Wed%20Apr%2001%2010:14:32%20GMT%202020

and it should be a timestamp

Any idea how to solve this?

[calvernaz]

I can say that the same query works in your example. The grafana version I'm using is newer v6, and that might be the difference?

[krishna1s]

Hi @calvernaz I tried with version 6 also, it seems not working.

Problem is start_time_left should be timestamp as you said, but it is coming as test plan name from the query.

Please suggest any solution for this if you have found

[calvernaz]

Hi @krishna1s, I had to use the same version in the example (Grafana 5) to have the same behaviour.

[krishna1s]

Thanks @calvernaz it seems to working in verson 5. Below query return timestamp value in variable, which makes it works, but it is not seems to be working with latest version. Any thought on this?

SELECT * FROM jmeter WHERE application =~ /$tag_left/ ORDER BY time asc LIMIT 1

Or is there any way in which we can select the perticular index value from the result of query to assign the variable value?