influxdata / influxdata/kapacitor

Tick script with multiple tag values

Open
#2,166 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
2.4k
Forks
479
Avg merge
4d 16h
Merged PRs (30d)
4

Description

I have a tick script where I have to run query with where clause on multiple interface_name which looks something like this:

`query('''SELECT last("state") as "value" FROM router.autogen.cisco_router where type = 'interface' and host = '10.66.14.82' and ("name"='GigabitEthernet0/0/0' OR "name"='GigabitEthernet0/0/1') ''')`
and this query run on influx db but kapacitor change this query to something like this:

`SELECT last("state") as "value" FROM router.autogen.cisco_router where type = 'interface' and host = '10.66.14.82' and (\"name\"='GigabitEthernet0/0/0' OR \"name\"='GigabitEthernet0/0/1')`
how to avoid \ befor " in tick script.

Contributor guide

Open the contributing guide

Research direction

The report provides no source file or test; start by reproducing the shown TICK query and comparing the query sent to InfluxDB with the original text. Done means determining whether Kapacitor incorrectly adds backslashes before the quoted tag values and documenting a verified fix or limitation.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.