{"action":"opened","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/7588","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/7588/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/7588/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/7588/events","html_url":"https://github.com/influxdata/influxdb/issues/7588","id":187495425,"number":7588,"title":"Feature Request - Support time in WHERE clause for SHOW TAG VALUES","user":{"login":"mvadu","id":8618235,"avatar_url":"https://avatars.githubusercontent.com/u/8618235?v=3","gravatar_id":"","url":"https://api.github.com/users/mvadu","html_url":"https://github.com/mvadu","followers_url":"https://api.github.com/users/mvadu/followers","following_url":"https://api.github.com/users/mvadu/following{/other_user}","gists_url":"https://api.github.com/users/mvadu/gists{/gist_id}","starred_url":"https://api.github.com/users/mvadu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mvadu/subscriptions","organizations_url":"https://api.github.com/users/mvadu/orgs","repos_url":"https://api.github.com/users/mvadu/repos","events_url":"https://api.github.com/users/mvadu/events{/privacy}","received_events_url":"https://api.github.com/users/mvadu/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-11-05T12:52:40Z","updated_at":"2016-11-05T12:52:40Z","closed_at":null,"body":"As part of #4385 functionality was added to block time part in WHERE clause in  SHOW TAG VALUES queries. e.g. `SHOW TAG VALUES FROM anomalies WITH KEY = \"ServerName\" where time > 1459520932s and time < 1459520932s + 6h`\r\n\r\n__Proposal:__ [Support time in WHERE clause for SHOW TAG VALUES]\r\n\r\n__Current behavior:__ [Server returned error: `SHOW TAG VALUES doesn't support time in WHERE clause`]\r\n\r\n__Desired behavior:__ [Return values for the given tag that appear in the time window given]\r\n\r\n__Use case:__ When you have very large data sets you can have hundreds of tag values. It becomes tedious task to display / select a specific tag values in visualization layer (grafana in my case). Grafana already supports refreshing template variables when time window changes.  If Influx supports time window, the dropdowns for the template variables can be assured to have a data point in the time window selected. It helps data analysis of large data sets even without involving grafana."}}
{"actor":{"display_login":"mvadu"}}