# Want to create a nest query to filter on optional field

**URL:** <https://discuss.elastic.co/t/want-to-create-a-nest-query-to-filter-on-optional-field/298433>\
**Category:** Elasticsearch\
**Tags:** language-clients\
**Created:** [February 28, 2022, 4:50pm UTC](https://discuss.elastic.co/t/want-to-create-a-nest-query-to-filter-on-optional-field/298433 "2022-02-28T16:50:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tony\_sid](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tony_sid/32/102421_2.png) [@tony\_sid](https://discuss.elastic.co/u/tony_sid)\
**Post date:** [February 28, 2022, 4:50pm UTC](https://discuss.elastic.co/t/want-to-create-a-nest-query-to-filter-on-optional-field/298433/1 "2022-02-28T16:50:02Z")

</div>

```auto

{
	{
		"id": 8,
                "teamId": 0,
                "experience": 1,
		"companyName": "MyCompany"
	},
	{
		"id": 9,
                "teamId": 0,
                "experience": 1,
	},
	{
		"id": 10,
                "teamId": 1,
                "experience": 1,
	},
	{
		"id": 11,
                "teamId": 1,
                "experience": 1,
	        "companyName": "MyCompany"
	}
}

```

// Here is my nest query

```auto
List<Func<QueryContainerDescriptor<SearchClass>, QueryContainer>> filters = new List<Func<QueryContainerDescriptor<SearchClass>, QueryContainer>>();
filters.Add(n => n.Term(trm => trm.CompanyName.ToLower(), companyName.ToLower()))

jobProfiles = await _searchClient.SearchAsync<JobProfileSearch>(descriptor => descriptor
                    .From(pageIndex == 0 ? pageIndex : pageIndex * pageSize)
                    .Size(pageSize)
                    .Query(q => q
                        .Exists(e => e.Field(p => p.CompanyName)))
                    .PostFilter(q => q
                        .QueryString(queryDescriptor => queryDescriptor
                           .Query($"*{searchString}*")
                           .Fields(fs => fs
                           .Field(p => p.experience, 10)
                           .Field(p => p.IndustryType, 5)
                           .Field(p => p.SubIndustryType, 3)))
                        )
                    .PostFilter(q => q.Bool(bq => bq.Filter(filters))));

```

When i try to apply this i am not getting any result. My need is to search for company name from object where company name exist

---

<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 28, 2022, 4:50pm UTC](https://discuss.elastic.co/t/want-to-create-a-nest-query-to-filter-on-optional-field/298433/2 "2022-03-28T16:50:04Z")

</div>

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