# Schema -- Every combination of tag keys and values

**URL:** <https://community.influxdata.com/t/schema-every-combination-of-tag-keys-and-values/23460>\
**Category:** InfluxDB 2\
**Tags:** schema, influxql, query, flux\
**Created:** [January 20, 2022, 3:17pm UTC](https://community.influxdata.com/t/schema-every-combination-of-tag-keys-and-values/23460 "2022-01-20T15:17:30Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ticchioned](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/ticchioned/32/9856_2.png) [@ticchioned](https://community.influxdata.com/u/ticchioned)\
**Post date:** [January 20, 2022, 3:17pm UTC](https://community.influxdata.com/t/schema-every-combination-of-tag-keys-and-values/23460/1 "2022-01-20T15:17:30Z")

</div>

I have a measurement within a bucket. The measurement has three possible tag keys and only one field. I have created a value at every possible combination of tag key and value… starting with no tag keys and ending with all three tag keys. the schema looks something like…

Measurement1,Tag1=A,Tag2=B,Tag3=C,Field=F – again, containing any combination of Tag1, Tag2, and Tag3

When I try to query for a value of a series that does not contain all three tag keys… for example – a series that does not contain Tag2.

from(bucket: “MyBucket”)  
|\> range(start: v.timeRangeStart, stop: v.timeRangeStop)  
|\> filter(fn: (r) =\> r.\_measurement == “M1” and r.Tag1 == “A” and r.Tag3 == “C” and r.\_field == “F”)  
|\> last()

The returned values will be for the series requested (series with only Tag1 and Tag3), but also any series containing r.Tag2 since I am unable to filter that out (wont have knowledge that that tag key exists at runtime).

Is there any way around this issue? Ive also noticed that if I use the flux query influx provides to return all possible tag keys (that way I could have knowledge of all possible tag keys at runtime) on a measurement, no tag keys are returned for this measurement. Why wont this call return any tag keys when there are multiple tag keys on this measurement?

import “influxdata/influxdb/schema”  
schema.measurementTagKeys(bucket: “MyBucket”, measurement: “Measurement1”)

Table and query from live results – Only Tag A and C were wanted. Tag B was brought back due to not being able to filter properly.

from(bucket: “DomsDB2”)  
|\> range(start: v.timeRangeStart, stop: v.timeRangeStop)  
|\> filter(fn: (r) =\> r.\_measurement == “M1” and r.A == “V1” and r.C == “V3” and r.\_field == “F”)  
|\> last()

| #group | FALSE | FALSE | TRUE | TRUE | FALSE | FALSE | TRUE | TRUE | TRUE | TRUE |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| #datatype | string | long | dateTime:RFC3339 | dateTime:RFC3339 | dateTime:RFC3339 | double | string | string | string | string |
| #default | \_result | | | | | | | | | |
| | result | table | \_start | \_stop | \_time | \_value | A | B | C | \_field |
| | | 0 | 2020-10-08T17:12:58Z | 2022-01-19T18:17:58.102Z | 2021-01-25T14:21:40Z | 123 | V1 | V2 | V3 | F |
| | | | | | | | | | | |
| #group | FALSE | FALSE | TRUE | TRUE | FALSE | FALSE | TRUE | TRUE | TRUE | TRUE |
| #datatype | string | long | dateTime:RFC3339 | dateTime:RFC3339 | dateTime:RFC3339 | double | string | string | string | string |
| #default | \_result | | | | | | | | | |
| | result | table | \_start | \_stop | \_time | \_value | A | C | \_field | \_measurement |
| | | 1 | 2020-10-08T17:12:58Z | 2022-01-19T18:17:58.102Z | 2021-01-25T14:21:40Z | 103 | V1 | V3 | F | M1 |
| ![image | 690x216](upload://2D9YBXnRy8XV3CYMzKTZ38RVZzR.png) | | | | | | | | | |