Or perhaps better show last(temp) from machines where time > now() - 1d
On Thursday, February 22, 2018 at 10:03:26 AM UTC-6, Frank Inselbuch wrote: > > I don't believe that can be done. > What you can do is query the measurement for a field value with a > timestamp in the last day. > For example > > select temp from machines where time > now() - 1d > > But you have to specify the measurement in the query. > > You could construct these queries for all measurements in a program (bash, > python, etc.) ... run show measurements to get the whole list of > measurements. > Then construct the above query for each measurement. > > Not ideal, I know. > > > > On Tuesday, February 13, 2018 at 1:11:11 PM UTC-6, Travis Keep wrote: >> >> > show measurements >> >> This shows all the measurements in a database, but I am interested in >> only the measurements that are newer than 1 day. If the measurement did >> not exist 1 day ago, I don't want it listed. How would one write such a >> query? >> >> >> -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/647f44f8-6f0f-4b9a-9019-3b78a5d603ba%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
