I’m having trouble with a query that uses a regex to specify the measurement. In a database with about a dozen measurements, when I run:
SELECT last(value) FROM alerta.autogen./Heart.*/ WHERE time > now() - 7d group by resource
it works as expected. There are two measurements that start with ‘Heart’, and I get a result from each for each value of the tag ‘resource’ and from each of those two measurements.
However, when I try to expand this to cover what I think should be every measurement in the database with:
SELECT last(value) FROM alerta.autogen./.*/ WHERE time > now() - 7d group by resource
I get results from only a single measurement (grouped by resource). This happens to be the alphabetically last measurement in the database, not sure if that is significant.
This is version 1.2.2 using a CLI query. Sorry if I’m doing something obviously wrong.