{"action":"opened","issue":{"url":"https://api.github.com/repos/grafana/grafana/issues/3689","labels_url":"https://api.github.com/repos/grafana/grafana/issues/3689/labels{/name}","comments_url":"https://api.github.com/repos/grafana/grafana/issues/3689/comments","events_url":"https://api.github.com/repos/grafana/grafana/issues/3689/events","html_url":"https://github.com/grafana/grafana/issues/3689","id":125671682,"number":3689,"title":"Feature Request: Support for influxdb '=~' operator in WHERE conditions","user":{"login":"sysadmin1139","id":812860,"avatar_url":"https://avatars.githubusercontent.com/u/812860?v=3","gravatar_id":"","url":"https://api.github.com/users/sysadmin1139","html_url":"https://github.com/sysadmin1139","followers_url":"https://api.github.com/users/sysadmin1139/followers","following_url":"https://api.github.com/users/sysadmin1139/following{/other_user}","gists_url":"https://api.github.com/users/sysadmin1139/gists{/gist_id}","starred_url":"https://api.github.com/users/sysadmin1139/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sysadmin1139/subscriptions","organizations_url":"https://api.github.com/users/sysadmin1139/orgs","repos_url":"https://api.github.com/users/sysadmin1139/repos","events_url":"https://api.github.com/users/sysadmin1139/events{/privacy}","received_events_url":"https://api.github.com/users/sysadmin1139/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-01-08T18:59:30Z","updated_at":"2016-01-08T18:59:30Z","closed_at":null,"body":"There is WHERE operator grafana doesn't support, but influx does, `=~`. Unlike a lot of influx stuff, this shouldn't require a complete reengineering of the UI. Here is an example query that uses it:\r\n\r\n    SELECT sum(value) \r\n    FROM hit_counters \r\n    WHERE\r\n        webapp =~ /api_[a-z]/ AND\r\n        time > now() - 2d \r\n    GROUP BY\r\n        time(5m), webapp\r\n\r\nThis will produce multiple time-series, and grafana is smart enough to chart them. When used with an alias like `$tag_webapp`, new API services willl automatically appear on the charts without having to edit the chart.\r\n![hitsbyapp](https://cloud.githubusercontent.com/assets/812860/12206615/89152204-b607-11e5-82f9-a3b69acbe83e.png)\r\nIt's pretty cool, and it would be great if it were in the query editor.\r\n"}}