# Newbie: Easiest way to view ES Results

**URL:** <https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940>\
**Category:** Elasticsearch\
**Created:** [June 7, 2018, 9:33am UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940 "2018-06-07T09:33:02Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dhiwakar\_Kusuma](https://avatars.discourse-cdn.com/v4/letter/d/779978/32.png) [@Dhiwakar\_Kusuma](https://discuss.elastic.co/u/Dhiwakar_Kusuma)\
**Post date:** [June 7, 2018, 9:33am UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/1 "2018-06-07T09:33:02Z")

</div>

Whats' the easiest way to view the ES Query results - I have '000s of documents in my index? Kibana console is making me feel tired ☹

---

<div class="post-metadata">

**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\
**Post date:** [June 7, 2018, 11:12am UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/2 "2018-06-07T11:12:07Z")

</div>

Kibana's "Discover" tab? You can pick which columns to view in a tabular form

---

<div class="post-metadata">

**Author:** ![Dhiwakar\_Kusuma](https://avatars.discourse-cdn.com/v4/letter/d/779978/32.png) [@Dhiwakar\_Kusuma](https://discuss.elastic.co/u/Dhiwakar_Kusuma)\
**Post date:** [June 8, 2018, 9:43am UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/3 "2018-06-08T09:43:39Z")

</div>

But, does discover tab allow you to put your own custom query? I couldn't find options there. We have a custom query with custom scoring logic.

---

<div class="post-metadata">

**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\
**Post date:** [June 8, 2018, 9:44am UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/4 "2018-06-08T09:44:16Z")

</div>

Yes - you can paste raw JSON strings into the search bar.

---

<div class="post-metadata">

**Author:** ![Dhiwakar\_Kusuma](https://avatars.discourse-cdn.com/v4/letter/d/779978/32.png) [@Dhiwakar\_Kusuma](https://discuss.elastic.co/u/Dhiwakar_Kusuma)\
**Post date:** [June 8, 2018, 9:48am UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/5 "2018-06-08T09:48:20Z")

</div>

I don't get it, when you say JSON are you referring to the output? I would be interested in posting my query like below and expect the results to be displayed in grid.

GET dummyindex/\_search  
{  
"size": 1,  
"query": {  
"bool": {  
"should": [  
{  
"match": {  
"skillkeywords.skillset.skill": "Salesforce"  
}  
},  
{  
"match": {  
"skillkeywords.skillset.skill": "AngularJS"  
}  
}  
],  
"minimum\_should\_match": "3\<90%",  
"boost": 1  
}  
}  
}

PS: Didn't expect such a fast response 🙂 ... it is almost like chatting!

---

<div class="post-metadata">

**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\
**Post date:** [June 8, 2018, 9:50am UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/6 "2018-06-08T09:50:03Z")

</div>

Hi, no I meant your query - that is JSON too. Specifically the bit after `"query":`

---

<div class="post-metadata">

**Author:** ![Dhiwakar\_Kusuma](https://avatars.discourse-cdn.com/v4/letter/d/779978/32.png) [@Dhiwakar\_Kusuma](https://discuss.elastic.co/u/Dhiwakar_Kusuma)\
**Post date:** [June 11, 2018, 8:26am UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/7 "2018-06-11T08:26:56Z")

</div>

Got it, thanks!

---

<div class="post-metadata">

**Author:** ![gthang](https://avatars.discourse-cdn.com/v4/letter/g/258eb7/32.png) [@gthang](https://discuss.elastic.co/u/gthang)\
**Post date:** [June 12, 2018, 3:20pm UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/8 "2018-06-12T15:20:18Z")

</div>

I am not sure if I can hijack this thread or not, please let me know if I have commited any faux-pas here, and I will start a new thread.

I have composed the following query in the dev tools, and when I try to copy the json portion after the search, I just get an error message. Any thoughts on how I should paste the query in the discover tool?

Thanks,  
gthang

POST stats-m-mms-daily/\_search  
{  
"query": {  
"range": {  
"@timestamp": {  
"gt": "now-5s",  
"lt": "now"  
}  
}  
},  
"size": 0,  
"aggs": {  
"cloud": {  
"terms": {  
"field": "groupName"  
},  
"aggs": {  
"instance": {  
"terms": {  
"field": "instance",  
"size": 1  
},  
"aggs": {  
"totalMessagesReq": {  
"sum": {  
"field": "CustomStats\_totalMessagesReq"  
}  
}  
}  
}  
}  
}  
}  
}

---

<div class="post-metadata">

**Author:** ![Dhiwakar\_Kusuma](https://avatars.discourse-cdn.com/v4/letter/d/779978/32.png) [@Dhiwakar\_Kusuma](https://discuss.elastic.co/u/Dhiwakar_Kusuma)\
**Post date:** [June 18, 2018, 5:49am UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/9 "2018-06-18T05:49:51Z")

</div>

Here is a simple example that will guide you -

If the query is  
GET myindex/\_search?search\_type=dfs\_query\_then\_fetch  
{  
"size": 5,  
"query": {  
"query\_string": {  
"query": "something something blah blah"  
}  
}  
}

Then, here is what you should be putting in the discover tab - Basically the whole text after the query keyword.

{ "query\_string": { "query": "something something blah blah" }}

Hope this helps.

---

<div class="post-metadata">

**Author:** ![gthang](https://avatars.discourse-cdn.com/v4/letter/g/258eb7/32.png) [@gthang](https://discuss.elastic.co/u/gthang)\
**Post date:** [June 19, 2018, 4:03pm UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/10 "2018-06-19T16:03:39Z")

</div>

Thank you very much!

---

<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:** [July 17, 2018, 4:03pm UTC](https://discuss.elastic.co/t/newbie-easiest-way-to-view-es-results/134940/11 "2018-07-17T16:03:39Z")

</div>

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