# Searching nested objects in kibana 6.1.1

**URL:** https://discuss.elastic.co/t/searching-nested-objects-in-kibana-6-1-1/253197
**Category:** Kibana
**Tags:** kql-kibana-query-language
**Created:** [October 24, 2020, 8:32am UTC](https://discuss.elastic.co/t/searching-nested-objects-in-kibana-6-1-1/253197 "2020-10-24T08:32:14Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![vvvprabhakar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vvvprabhakar/32/53806_2.png) [@vvvprabhakar](https://discuss.elastic.co/u/vvvprabhakar)
#### Post date: [October 24, 2020, 8:32am UTC](https://discuss.elastic.co/t/searching-nested-objects-in-kibana-6-1-1/253197/1 "2020-10-24T08:32:15Z")

</div>

![Screenshot 2020-10-24 at 13.55.34](https://us1.discourse-cdn.com/elastic/original/3X/d/a/da7b9766301ceeac7b2acc7a0bfda5afdbf5880d.png)

```auto
logs :
	 {
	 	"fields": [{
	 			"value": "exception",
	 			"type": "string",
	 			"key": "message"
	 		},
	 		{
	 			"value": "Access denied to perform this action",
	 			"type": "string",
	 			"key": "exception.message"
	 		},
	 		{
	 			"value": "com.AccessDeniedException: Access denied to perform this action\n",
	 			"type": "string",
	 			"key": "exception.stacktrace"
	 		},
	 		{
	 			"value": "com.AccessDeniedException",
	 			"type": "string",
	 			"key": "exception.type"
	 		}
	 	],
	 	"timestamp": 123
	 }

```

i want to query the concat all the values present in the fields array object  
from the above example it should be  
"exception com.AccessDeniedException: Access denied to perform this action\n "com.AccessDeniedException"

How to write a query for this ?

And one more question is for logs attribute kibana is showing "Unindexed fields cannot be searched "  
How can i filter those

Thanks in advance

---

<div class="post-metadata">

### Author: ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)
#### Post date: [October 29, 2020, 7:53pm UTC](https://discuss.elastic.co/t/searching-nested-objects-in-kibana-6-1-1/253197/2 "2020-10-29T19:53:31Z")

</div>

Hi, the part in your question about "query the concat all the values" isn't very clear. It might help your understanding to read about how nested fields work in Elasticsearch: [https://www.elastic.co/guide/en/elasticsearch/reference/current/nested.html#nested](https://www.elastic.co/guide/en/elasticsearch/reference/current/nested.html#nested)

Kibana currently does not have support for searching nested fields. Your best option would be to create a scripted field and use that field as the value to search. Another option is to change the way the data is ingested so the search-friendly text is an additional field in the data.

---

<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 26, 2020, 7:53pm UTC](https://discuss.elastic.co/t/searching-nested-objects-in-kibana-6-1-1/253197/3 "2020-11-26T19:53:33Z")

</div>

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