# Search value based on specific field as child field are dynamic

**URL:** <https://discuss.elastic.co/t/search-value-based-on-specific-field-as-child-field-are-dynamic/252957>\
**Category:** Elasticsearch\
**Created:** [October 22, 2020, 7:54am UTC](https://discuss.elastic.co/t/search-value-based-on-specific-field-as-child-field-are-dynamic/252957 "2020-10-22T07:54:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ROHITHPR](https://avatars.discourse-cdn.com/v4/letter/r/8491ac/32.png) [@ROHITHPR](https://discuss.elastic.co/u/ROHITHPR)\
**Post date:** [October 22, 2020, 7:54am UTC](https://discuss.elastic.co/t/search-value-based-on-specific-field-as-child-field-are-dynamic/252957/1 "2020-10-22T07:54:23Z")

</div>

The collection looks like this

```
                {
                   "displayname":"unknown12"
                        "hierarchy":{
                                "username":"Nothing on",
                                "Location":"",
                                "Owner":"unknown",
                                "works": "IT"
                            }
                    } 

```

using a multi-match query with phrase\_prefix, want to search value based on fields. **The fields within the hierarchy are dynamic. Want to search field based on specific fields**

```auto
        {
        "from": 0,
                "query": {
                "multi_match": {
                    "query": "Finance",
                    "type": "phrase_prefix",
                    "fields": [
                        "Location",
                        "address",
                        "hierarchy.*.",
                        "tags"
                    ]
                }
            }
    }

```

**To search IT we should specify like hierarchy.works or for unknown hierarchy.Owner,** as it is dynamic cant specify for all, trying with regex but getting an error, is there any way to get it.HOe

---

<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 19, 2020, 7:54am UTC](https://discuss.elastic.co/t/search-value-based-on-specific-field-as-child-field-are-dynamic/252957/2 "2020-11-19T07:54:28Z")

</div>

Closed on November 19, 2020, 7:54am UTC

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