[influxdb] variables in kapacitor queriesla

[joblx88]

kapacitor 1.1, influx 1.1

I'm trying to create a template.  In the template, I'd like to include a 
parameter in the batch query.  Here is what i got

var myperiod=60m
var mytime=60m
var myevery=60m



var success  = batch
    |query('''SELECT count(jobRunTime) FROM "metrics"."days30"."tasks" where 
"component"='site' and "taskType"='Task1' and "status" = 'FINISHED' ''')
        .period(myperiod)
        .every(myevery)
        .groupBy(time(mytime), 'id','serverID')
        .align()
        .fill(0)



I want this

var myperiod=60m
var mytime=60m
var myevery=60m
var taskType='Task2'


var success  = batch
    |query('''SELECT count(jobRunTime) FROM "metrics"."days30"."tasks" where 
"component"='site' and "taskType"=$taskType and "status" = 'FINISHED' ''')
        .period(myperiod)
        .every(myevery)
        .groupBy(time(mytime), 'id','serverID')
        .align()
        .fill(0)

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/b373ac00-8042-4034-b94f-f463dcb6ed0b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.