query.editor.html 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300
  1. <div class="editor-row">
  2. <div ng-repeat="target in panel.targets" ng-controller="ElasticQueryCtrl" ng-init="init()" ng-class="{'tight-form-disabled': target.hide}" class="tight-form-container-no-item-borders" style="margin-bottom: 10px">
  3. <div class="tight-form">
  4. <ul class="tight-form-list pull-right">
  5. <li ng-show="parserError" class="tight-form-item">
  6. <a bs-tooltip="parserError" style="color: rgb(229, 189, 28)" role="menuitem">
  7. <i class="fa fa-warning"></i>
  8. </a>
  9. </li>
  10. <li class="tight-form-item">
  11. <a class="pointer" tabindex="1" ng-click="toggleQueryMode()">
  12. <i class="fa fa-pencil"></i>
  13. </a>
  14. </li>
  15. <li class="tight-form-item">
  16. <div class="dropdown">
  17. <a class="pointer dropdown-toggle"
  18. data-toggle="dropdown"
  19. tabindex="1">
  20. <i class="fa fa-bars"></i>
  21. </a>
  22. <ul class="dropdown-menu pull-right" role="menu">
  23. <li role="menuitem">
  24. <a tabindex="1"
  25. ng-click="duplicate()">
  26. Duplicate
  27. </a>
  28. </li>
  29. <li role="menuitem">
  30. <a tabindex="1"
  31. ng-click="moveMetricQuery($index, $index-1)">
  32. Move up
  33. </a>
  34. </li>
  35. <li role="menuitem">
  36. <a tabindex="1"
  37. ng-click="moveMetricQuery($index, $index+1)">
  38. Move down
  39. </a>
  40. </li>
  41. </ul>
  42. </div>
  43. </li>
  44. <li class="tight-form-item last">
  45. <a class="pointer" tabindex="1" ng-click="removeDataQuery(target)">
  46. <i class="fa fa-remove"></i>
  47. </a>
  48. </li>
  49. </ul>
  50. <ul class="tight-form-list">
  51. <li>
  52. <a class="tight-form-item"
  53. ng-click="target.hide = !target.hide; get_data();"
  54. role="menuitem">
  55. <i class="fa fa-eye"></i>
  56. </a>
  57. </li>
  58. </ul>
  59. <input type="text" class="tight-form-clear-input" style="width: 80%" ng-model="target.query" focus-me="target.rawQuery" spellcheck='false' ng-model-onblur ng-change="get_data()" ng-show="target.rawQuery"/>
  60. <ul class="tight-form-list" role="menu" ng-hide="target.rawQuery">
  61. <li class="tight-form-item query-keyword" style="width: 75px;">
  62. Function
  63. </li>
  64. <li class="dropdown tight-form-item">
  65. <a gf-dropdown="functionMenu" class="dropdown-toggle" data-toggle="dropdown">
  66. {{target.function}}<span>(value)</span>
  67. </a>
  68. </li>
  69. </ul>
  70. <div class="clearfix"></div>
  71. </div>
  72. <!-- <div class="tight-form" ng-hide="target.rawQuery">
  73. <ul class="tight-form-list">
  74. <li class="tight-form-item">
  75. <i class="fa fa-eye invisible"></i>
  76. </li>
  77. <li class="tight-form-item query-keyword" style="width: 75px;">
  78. Measurement
  79. </li>
  80. <li>
  81. <metric-segment segment="measurementSegment" get-alt-segments="getMeasurements()" on-value-changed="measurementChanged()"></metric-segment>
  82. </li>
  83. </ul>
  84. <div class="clearfix"></div>
  85. </div> -->
  86. <div class="tight-form" ng-hide="target.rawQuery">
  87. <ul class="tight-form-list">
  88. <li class="tight-form-item">
  89. <i class="fa fa-eye invisible"></i>
  90. </li>
  91. <li class="tight-form-item query-keyword" style="width: 75px;">
  92. Key Field
  93. </li>
  94. <li>
  95. <metric-segment segment="keyFieldSegment" on-value-changed="keyFieldChanged()"></metric-segment>
  96. </li>
  97. </ul>
  98. <div class="clearfix"></div>
  99. </div>
  100. <div class="tight-form" ng-hide="target.rawQuery">
  101. <ul class="tight-form-list">
  102. <li class="tight-form-item">
  103. <i class="fa fa-eye invisible"></i>
  104. </li>
  105. <li class="tight-form-item query-keyword" style="width: 75px;">
  106. Value Field
  107. </li>
  108. <li>
  109. <metric-segment segment="valueFieldSegment" on-value-changed="valueFieldChanged()"></metric-segment>
  110. </li>
  111. </ul>
  112. <div class="clearfix"></div>
  113. </div>
  114. <div class="tight-form" ng-hide="target.rawQuery">
  115. <ul class="tight-form-list">
  116. <li class="tight-form-item">
  117. <i class="fa fa-eye invisible"></i>
  118. </li>
  119. <li class="tight-form-item query-keyword" style="width: 75px;">
  120. Term
  121. </li>
  122. <li>
  123. <metric-segment segment="termKeySegment" on-value-changed="termKeySegmentChanged()"></metric-segment>
  124. </li>
  125. <li>
  126. <span class="tight-form-item">:</span>
  127. </li>
  128. <li>
  129. <metric-segment segment="termValueSegment" on-value-changed="termValueSegmentChanged()"></metric-segment>
  130. </li>
  131. </ul>
  132. <div class="clearfix"></div>
  133. </div>
  134. <!-- <div class="tight-form" ng-hide="target.rawQuery">
  135. <ul class="tight-form-list">
  136. <li class="tight-form-item">
  137. <i class="fa fa-eye invisible"></i>
  138. </li>
  139. <li class="tight-form-item query-keyword" style="width: 75px;">
  140. WHERE
  141. </li>
  142. <li ng-repeat="segment in tagSegments">
  143. <metric-segment segment="segment" get-alt-segments="getTagsOrValues(segment, $index)" on-value-changed="tagSegmentUpdated(segment, $index)"></metric-segment>
  144. </li>
  145. </ul>
  146. <div class="clearfix"></div>
  147. </div> -->
  148. <!-- <div class="tight-form">
  149. <ul class="tight-form-list" ng-hide="target.rawQuery">
  150. <li class="tight-form-item">
  151. <i class="fa fa-eye invisible"></i>
  152. </li>
  153. <li class="tight-form-item" >
  154. <span class="query-keyword">GROUP BY</span>
  155. </li>
  156. <li class="tight-form-item">
  157. time($interval)
  158. </li>
  159. <li ng-repeat="segment in groupBySegments">
  160. <metric-segment segment="segment" get-alt-segments="getGroupByTagSegments(segment, 0)" on-value-changed="groupByTagUpdated(segment, $index)"></metric-segment>
  161. </li>
  162. <li class="dropdown">
  163. <a class="tight-form-item pointer" data-toggle="dropdown" bs-tooltip="'Insert missing values, important when stacking'" data-placement="right">
  164. <span ng-show="target.fill">
  165. fill ({{target.fill}})
  166. </span>
  167. <span ng-show="!target.fill">
  168. no fill
  169. </span>
  170. </a>
  171. <ul class="dropdown-menu">
  172. <li><a ng-click="target.fill = ''">no fill</a></li>
  173. <li><a ng-click="target.fill = 'null'">fill (null)</a></li>
  174. <li><a ng-click="target.fill = '0'">fill (0)</a></li>
  175. </ul>
  176. </li>
  177. </ul>
  178. <ul class="tight-form-list pull-right">
  179. <li class="tight-form-item">
  180. Alias pattern
  181. </li>
  182. <li>
  183. <input type="text" class="input-medium tight-form-input" ng-model="target.alias" spellcheck='false' placeholder="alias" ng-blur="get_data()">
  184. </li>
  185. </ul>
  186. <div class="clearfix"></div>
  187. </div> -->
  188. </div>
  189. </div>
  190. <section class="grafana-metric-options">
  191. <div class="tight-form">
  192. <ul class="tight-form-list">
  193. <li class="tight-form-item tight-form-item-icon">
  194. <i class="fa fa-wrench"></i>
  195. </li>
  196. <li class="tight-form-item">
  197. Group by time interval
  198. </li>
  199. <li>
  200. <input type="text" class="input-medium tight-form-input" ng-model="panel.interval" ng-blur="get_data();"
  201. spellcheck='false' placeholder="example: >10s">
  202. </li>
  203. <li class="tight-form-item">
  204. <i class="fa fa-question-circle" bs-tooltip="'Set a low limit by having a greater sign: example: >60s'" data-placement="right"></i>
  205. </li>
  206. </ul>
  207. <div class="clearfix"></div>
  208. </div>
  209. <div class="tight-form">
  210. <ul class="tight-form-list">
  211. <li class="tight-form-item tight-form-item-icon">
  212. <i class="fa fa-info-circle"></i>
  213. </li>
  214. <li class="tight-form-item">
  215. <a ng-click="toggleEditorHelp(1);" bs-tooltip="'click to show helpful info'" data-placement="bottom">
  216. alias patterns
  217. </a>
  218. </li>
  219. <li class="tight-form-item">
  220. <a ng-click="toggleEditorHelp(2)" bs-tooltip="'click to show helpful info'" data-placement="bottom">
  221. stacking &amp; and fill
  222. </a>
  223. </li>
  224. <li class="tight-form-item">
  225. <a ng-click="toggleEditorHelp(3)" bs-tooltip="'click to show helpful info'" data-placement="bottom">
  226. group by time
  227. </a>
  228. </li>
  229. </ul>
  230. <div class="clearfix"></div>
  231. </div>
  232. </section>
  233. <div class="editor-row">
  234. <div class="pull-left" style="margin-top: 30px;">
  235. <div class="grafana-info-box span6" ng-if="editorHelpIndex === 1">
  236. <h5>Alias patterns</h5>
  237. <ul>
  238. <li>$m = replaced with measurement name</li>
  239. <li>$measurement = replaced with measurement name</li>
  240. <li>$tag_hostname = replaced with the value of the hostname tag</li>
  241. <li>You can also use [[tag_hostname]] pattern replacement syntax</li>
  242. </ul>
  243. </div>
  244. <div class="grafana-info-box span6" ng-if="editorHelpIndex === 2">
  245. <h5>Stacking and fill</h5>
  246. <ul>
  247. <li>When stacking is enabled it important that points align</li>
  248. <li>If there are missing points for one series it can cause gaps or missing bars</li>
  249. <li>You must use fill(0), and select a group by time low limit</li>
  250. <li>Use the group by time option below your queries and specify for example &gt;10s if your metrics are written every 10 seconds</li>
  251. <li>This will insert zeros for series that are missing measurements and will make stacking work properly</li>
  252. </ul>
  253. </div>
  254. <div class="grafana-info-box span6" ng-if="editorHelpIndex === 3">
  255. <h5>Group by time</h5>
  256. <ul>
  257. <li>Group by time is important, otherwise the query could return many thousands of datapoints that will slow down Grafana</li>
  258. <li>Leave the group by time field empty for each query and it will be calculated based on time range and pixel width of the graph</li>
  259. <li>If you use fill(0) or fill(null) set a low limit for the auto group by time interval</li>
  260. <li>The low limit can only be set in the group by time option below your queries</li>
  261. <li>You set a low limit by adding a greater sign before the interval</li>
  262. <li>Example: &gt;60s if you write metrics to ElasticDB every 60 seconds</li>
  263. </ul>
  264. </div>
  265. </div>
  266. </div>