# Finding the script/query behind a table

**URL:** https://discuss.elastic.co/t/finding-the-script-query-behind-a-table/80032
**Category:** Kibana
**Created:** [March 26, 2017, 8:27am UTC](https://discuss.elastic.co/t/finding-the-script-query-behind-a-table/80032 "2017-03-26T08:27:16Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![tomer](https://avatars.discourse-cdn.com/v4/letter/t/41988e/32.png) [@tomer](https://discuss.elastic.co/u/tomer)
#### Post date: [March 26, 2017, 8:27am UTC](https://discuss.elastic.co/t/finding-the-script-query-behind-a-table/80032/1 "2017-03-26T08:27:16Z")

</div>

How can I found the script/query behind a table (Kibana 5).

For an example in this table:

 ![](https://us1.discourse-cdn.com/elastic/original/3X/0/2/022e8dc18ab7559efa8c331df789ab6907548538.png)

I want to see the query on how to get the field of hits.total (that is equal to 96)

---

<div class="post-metadata">

### Author: ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)
#### Post date: [March 27, 2017, 5:05am UTC](https://discuss.elastic.co/t/finding-the-script-query-behind-a-table/80032/2 "2017-03-27T05:05:19Z")

</div>

Hi @tomer,

on every visualization there is a small arrow at the bottom:

 ![](https://us1.discourse-cdn.com/elastic/original/3X/9/5/95ca92df5d35aac2d41a4b280553e1357e2ee2e8.png)

Upon clicking that arrow, Kibana will show various textual information about the visualization including the query used to fetch the displayed data:

 ![](https://us1.discourse-cdn.com/elastic/original/3X/3/4/3499d735b59438846cafad2378271743715cad90.jpg)

---

<div class="post-metadata">

### Author: ![tomer](https://avatars.discourse-cdn.com/v4/letter/t/41988e/32.png) [@tomer](https://discuss.elastic.co/u/tomer)
#### Post date: [March 27, 2017, 6:23am UTC](https://discuss.elastic.co/t/finding-the-script-query-behind-a-table/80032/3 "2017-03-27T06:23:47Z")

</div>

Thanks this will save me a lot of time!!

---

<div class="post-metadata">

### Author: ![AlexM](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexm/32/16763_2.png) [@AlexM](https://discuss.elastic.co/u/AlexM)
#### Post date: [March 27, 2017, 8:33am UTC](https://discuss.elastic.co/t/finding-the-script-query-behind-a-table/80032/4 "2017-03-27T08:33:13Z")

</div>

Hello @weltenwort,  
How to enable this option "Debug" in any type of visualization? there is no this feature in my Kibana (Version: 5.2.2) ☹

![](https://us1.discourse-cdn.com/elastic/original/3X/7/6/762238a00bee8c0b50902ab1d9fc641e78442381.JPG)  
 ![](https://us1.discourse-cdn.com/elastic/original/3X/2/6/26ae1f77e566662a0aaa72702990b04260fd65dd.JPG)

---

<div class="post-metadata">

### Author: ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)
#### Post date: [March 27, 2017, 8:42am UTC](https://discuss.elastic.co/t/finding-the-script-query-behind-a-table/80032/5 "2017-03-27T08:42:40Z")

</div>

I was taking the screenshot while running Kibana in development mode (with `--dev`). The "Debug" panel displays some internals about the visualization useful for debugging during development.

---

<div class="post-metadata">

### Author: ![AlexM](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexm/32/16763_2.png) [@AlexM](https://discuss.elastic.co/u/AlexM)
#### Post date: [March 27, 2017, 11:47am UTC](https://discuss.elastic.co/t/finding-the-script-query-behind-a-table/80032/6 "2017-03-27T11:47:29Z")

</div>

Thanks for reply,  
So can you change the requst in the debug window?  
For example I want to change colors and other atributes, but in Request there are no thise features.

Can you please describe more about Debug, or doc. Thanks you very much.

---

<div class="post-metadata">

### Author: ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)
#### Post date: [March 27, 2017, 12:35pm UTC](https://discuss.elastic.co/t/finding-the-script-query-behind-a-table/80032/7 "2017-03-27T12:35:53Z")

</div>

The "Debug" window just displays some internal values of the visualization configuration for debugging during developent. In order to change the color associated with a bucket, just click a legend entry on the right to open a color picker. The configurable attributes of each visualization type are described in [the documentation](https://www.elastic.co/guide/en/kibana/current/createvis.html).

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 24, 2017, 12:36pm UTC](https://discuss.elastic.co/t/finding-the-script-query-behind-a-table/80032/8 "2017-04-24T12:36:12Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
