Can i do IN operation in influxdb2 with flux language?

debnath · January 17, 2022, 1:23pm

Hi,

I am very thankful to you guys for the help. Specially to @Anaisdg. I learn a lot and many more to learn.

My problem is i want to do a IN operation like SQL -

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

I want to apply the same with Flux.

Can you share any example for this.

samdillard · January 18, 2022, 3:50pm

@debnath That isn’t specifically available. The way to effectively achieve this is to use either regexp if the naming follows a pattern…or a string of or statements when filtering if it does not.

debnath · January 21, 2022, 6:40am

Thank you @samdillard for the help. Appreciated

samdillard · January 25, 2022, 8:13pm

@debnath actually I lied – try out contains: contains() function | Flux 0.x Documentation

debnath · January 26, 2022, 5:00am

@samdillard this is perfect. Thank you.
One request, I have posted a question 2days back no one replied. can you please help me out with that issue?
Link - Need result with Nested Json Object based on group