To filter multiple values you can just use OR, something like (id=1 OR id = 2)`, but since you don’t have a fixed set of values you can’t just put some static ids in there… This will be true for any system, not just InfluxDB.
you might get something that works using Grafana Template Variables as that will allow you to filter by a list, and use that filter wherever you want without actually writing fixed values in your query… if this is suitable I can’t tell, as it’s up to the use case
I don’t think so… if I understand it correctly no system will actually allow you to do so in a flexible way…
I will use an example to explain myself… let’s say you want to get a list of products…
| Category | Product |
| A | 1 |
| A | 2 |
| A | 3 |
| B | 4 |
you can logically write a query that does WHERE Product IN (1,2,3) to fetch the products, but it won’t “scale”, if any product gets moved/deleted/added you will have to keep editing it… which is just madness… what you want to do is use WHERE Category = 'A' as it will always work no matter what, without any need for editing unless the logic changes.
The problem is, you need an attribute to do so, in the case above I’ve used category, in your case I don’t any suitable attribute to filter those data…
if you actually explain what you want to achieve in the end I might understand something more about your requirement