# 0 hits in preview result with custom query

**URL:** <https://discuss.elastic.co/t/0-hits-in-preview-result-with-custom-query/315484>\
**Category:** Kibana\
**Tags:** detection-rules\
**Created:** [September 29, 2022, 4:50pm UTC](https://discuss.elastic.co/t/0-hits-in-preview-result-with-custom-query/315484 "2022-09-29T16:50:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![irivas95](https://avatars.discourse-cdn.com/v4/letter/i/839c29/32.png) [@irivas95](https://discuss.elastic.co/u/irivas95)\
**Post date:** [September 29, 2022, 4:50pm UTC](https://discuss.elastic.co/t/0-hits-in-preview-result-with-custom-query/315484/1 "2022-09-29T16:50:00Z")

</div>

Hi,  
I am trying to create a custom query detection rule in kibana 7.16, the query is as simple as this:

```auto
 dstcountry.keyword : "Spain" 

```

when i click on preview results it returns 0 hits, but in the discover i get almost 10000 hits. what can it be due to?  
Thanks in advance.

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [October 24, 2022, 1:56pm UTC](https://discuss.elastic.co/t/0-hits-in-preview-result-with-custom-query/315484/2 "2022-10-24T13:56:10Z")

</div>

Are you sure you set up correctly the indices and time field? Just checked (on 8.4.3) and it works as expected.

![Peek 2022-10-24 15-54](https://us1.discourse-cdn.com/elastic/original/3X/c/f/cffc284c16881dbae28bcdc60d02601c7fe7c1bd.gif)

Have you tried using KQL instead?, it asks for a data view (index pattern) so the time field is already defined for you.

---

<div class="post-metadata">

**Author:** ![irivas95](https://avatars.discourse-cdn.com/v4/letter/i/839c29/32.png) [@irivas95](https://discuss.elastic.co/u/irivas95)\
**Post date:** [October 25, 2022, 2:15pm UTC](https://discuss.elastic.co/t/0-hits-in-preview-result-with-custom-query/315484/3 "2022-10-25T14:15:09Z")

</div>

I had misconfigured the rule, thanks anyway.

---

<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:** [November 21, 2022, 11:54am UTC](https://discuss.elastic.co/t/0-hits-in-preview-result-with-custom-query/315484/4 "2022-11-21T11:54:38Z")

</div>



---

<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:** [December 19, 2022, 8:40am UTC](https://discuss.elastic.co/t/0-hits-in-preview-result-with-custom-query/315484/5 "2022-12-19T08:40:03Z")

</div>



---

<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:** [January 16, 2023, 8:40am UTC](https://discuss.elastic.co/t/0-hits-in-preview-result-with-custom-query/315484/6 "2023-01-16T08:40:38Z")

</div>

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