# Updated Index has data but not showing in the hits

**URL:** <https://discuss.elastic.co/t/updated-index-has-data-but-not-showing-in-the-hits/360769>\
**Category:** Elastic Search\
**Created:** [June 4, 2024, 10:04am UTC](https://discuss.elastic.co/t/updated-index-has-data-but-not-showing-in-the-hits/360769 "2024-06-04T10:04:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![joshua26](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joshua26/32/126246_2.png) [@joshua26](https://discuss.elastic.co/u/joshua26)\
**Post date:** [June 4, 2024, 10:04am UTC](https://discuss.elastic.co/t/updated-index-has-data-but-not-showing-in-the-hits/360769/1 "2024-06-04T10:04:17Z")

</div>

Hi,

I'm using Elasticsearch for query search of indexed data. Each document contains 116 fields (text) and 116 values (keyword). I'm able to load to an index properly. When I tried searching for newly updated data in the index using Kibana Query it's not showing any hit but if I use the auto generated \_id it's showing the result. When I query for \_cat /indices I can see the number of documents increased. I have checked the mappings; it is correct and the same as before. How to resolve this?  
Thanks in advance!

Best Regards,  
Joshua Ravi

---

<div class="post-metadata">

**Author:** ![efegurkan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/efegurkan/32/134429_2.png) [@efegurkan](https://discuss.elastic.co/u/efegurkan)\
**Post date:** [June 4, 2024, 10:14am UTC](https://discuss.elastic.co/t/updated-index-has-data-but-not-showing-in-the-hits/360769/2 "2024-06-04T10:14:25Z")

</div>

Hey @joshua26,

Can you check if your search query is correct. If you see the \_count go up it means that documents are indexed. If you can give more information on the query that would be helpful

You should be able to do the same query in Kibana DevTools.

`GET <index-name>/_count` first to make sure documents are indexed. Which I think you already certain for that.

```auto
POST <index-name>/_search`
{
    // your query here`
}

```

---

<div class="post-metadata">

**Author:** ![joshua26](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joshua26/32/126246_2.png) [@joshua26](https://discuss.elastic.co/u/joshua26)\
**Post date:** [June 4, 2024, 12:04pm UTC](https://discuss.elastic.co/t/updated-index-has-data-but-not-showing-in-the-hits/360769/3 "2024-06-04T12:04:28Z")

</div>

Hi @efegurkan,

Thanks for quick response, I have tried as you suggested and included the query, output below.  
for POST API, I have tried match, term, .keyword still not showing any hits.

```auto
GET grch_final/_count
output
{
  "count": 537480235,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  }
}
query:
POST grch_final/_search
{
 "query": {
    "term": {
      "variation": "14_19000050_G/A"
    }
  }
}

output:
{
  "took": 1,
  "timed_out": false,
  "_shards": {
    "total": 1,
    "successful": 1,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": {
      "value": 0,
      "relation": "eq"
    },
    "max_score": null,
    "hits": []
  }
}

```

---

<div class="post-metadata">

**Author:** ![joemcelroy](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joemcelroy/32/103757_2.png) [@joemcelroy](https://discuss.elastic.co/u/joemcelroy)\
**Post date:** [June 4, 2024, 12:22pm UTC](https://discuss.elastic.co/t/updated-index-has-data-but-not-showing-in-the-hits/360769/4 "2024-06-04T12:22:47Z")

</div>

looking at your query, do you want to filter fits based on your condition?

Take a look at the index mappings, "variation" maybe a text field here and what it appears you want is doing a term query on a keyword field to do exact match.

You can find the index mappings via `GET grch_final/_mapping`

We have a search tutorial that maybe helpful here [Filters — Elastic Search Labs](https://www.elastic.co/search-labs/tutorials/search-tutorial/full-text-search/filters)

Also worth reading through this notebook to understand all the different types of querying and filtering thats on offer and the type of fields they need to be aswell.

> <https://github.com/elastic/elasticsearch-labs/blob/main/notebooks/search/01-keyword-querying-filtering.ipynb>

Joe

---

<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 2, 2024, 12:23pm UTC](https://discuss.elastic.co/t/updated-index-has-data-but-not-showing-in-the-hits/360769/5 "2024-07-02T12:23:26Z")

</div>

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