Documentation

schema.tagValues() function

The schema.tagValues() function returns a list of unique values for a given tag. The return value is always a single table with a single column, _value.

import "influxdata/influxdb/schema"

schema.tagValues(
  bucket: "example-bucket",
  tag: "host",
  predicate: (r) => true,
  start: -30d
)

Parameters

bucket

Bucket to return unique tag values from.

Data type: String

tag

Tag to return unique values from.

Data type: String

predicate

Predicate function that filters tag values. Defaults to (r) => true.

Data type: Function

start

Oldest time to include in results. Defaults to -30d.

Relative start times are defined using negative durations. Negative durations are relative to now. Absolute start times are defined using time values.

Data type: Duration

Examples

import "influxdata/influxdb/schema"

schema.tagValues(
  bucket: "my-bucket",
  tag: "host",
)

Function definition

package schema

tagValues = (bucket, tag, predicate=(r) => true, start=-30d) =>
  from(bucket: bucket)
    |> range(start: start)
    |> filter(fn: predicate)
    |> group(columns: [tag])
    |> distinct(column: tag)
    |> keep(columns: ["_value"])

Used functions: from, range, filter, group, distinct, keep


Set your InfluxDB URL

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.