# Query sample of each field in index

**URL:** <https://discuss.elastic.co/t/query-sample-of-each-field-in-index/296370>\
**Category:** Elasticsearch\
**Created:** [February 5, 2022, 10:11pm UTC](https://discuss.elastic.co/t/query-sample-of-each-field-in-index/296370 "2022-02-05T22:11:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Petr.Simik](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/petr.simik/32/38082_2.png) [@Petr.Simik](https://discuss.elastic.co/u/Petr.Simik)\
**Post date:** [February 5, 2022, 10:11pm UTC](https://discuss.elastic.co/t/query-sample-of-each-field-in-index/296370/1 "2022-02-05T22:11:41Z")

</div>

I am trying to develop data-catalog app  
this app shows all fields (in flat dict format) its mapping type and sample data

for instance this index

> POST test/\_doc  
> {  
> "@timestamp": "2099-11-15T13:12:00",  
> "message": "GET /search HTTP/1.1 200 1070000",  
> "user": {  
> "id": "kimchy"  
> },  
> "nested": { "subnest":{"key":"value"}}  
> }

is displayed this way

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/5/b5185d4631ea465876e9fcd6583b1348f24f3a8f.png)

But I have a problem in indexes with much more fields where field exists rarely.

I am looking for query where I can query sample data for each field.  
Should I exists-query for every field or is there any other way?  
Thank you

---

<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:** [March 5, 2022, 10:12pm UTC](https://discuss.elastic.co/t/query-sample-of-each-field-in-index/296370/2 "2022-03-05T22:12:31Z")

</div>

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