Multi select not working

1

Hi,

When I try to select the below query

from(bucket: “bucketname”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn:(r) =>r[“_measurement”] == “measurement”)
|> filter(fn: (r) => r[“column1”] == “‘value1’,‘value2’”")
|> last()
|> group()
|> keyValues(keyColumns: [“column1”])
|> drop(columns:[“_tag1”])

it is not working. Only single select of column1 is working. I have to keep either value1 or value2. Is it possible to keep more than one value

Regards
Sudheer

2

first, I am assuming column1 is a tag,
second, I don’t think you could do multi select like that.
I use or condition.
|> filter(fn: (r) => r["name"] == "name1" or r["name"] == "name2" or r["name"] == "name3" )

@AVVS_Sudheer I think you are not understanding the basic concepts of InfluxDB, I mean that not wrong everyone starts not knowing something, but you should take a look a t the documentation and examples to start understanding the basics first.

3

You can use regex:
from(bucket: “bucketname”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn:(r) =>r[“_measurement”] == “measurement”)
|> filter(fn: (r) => r[“column1”] =~ /value1|value2/)
|> last()
|> group()
|> keyValues(keyColumns: [“column1”])
|> drop(columns:[“_tag1”])

4

Hi,

Now it is working fine. I have used regex.

Regards
Sudheer