# Need to convert dsl query to NEST

**URL:** <https://discuss.elastic.co/t/need-to-convert-dsl-query-to-nest/214202>\
**Category:** Elasticsearch\
**Tags:** language-clients\
**Created:** [January 8, 2020, 9:48am UTC](https://discuss.elastic.co/t/need-to-convert-dsl-query-to-nest/214202 "2020-01-08T09:48:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![arvindK\_sharma](https://avatars.discourse-cdn.com/v4/letter/a/a9a28c/32.png) [@arvindK\_sharma](https://discuss.elastic.co/u/arvindK_sharma)\
**Post date:** [January 8, 2020, 9:48am UTC](https://discuss.elastic.co/t/need-to-convert-dsl-query-to-nest/214202/1 "2020-01-08T09:48:37Z")

</div>

I have dsl following query  
get /metricbeat\*/\_search?pretty=true  
{  
"aggs": {  
"3": {  
"terms": {  
"field": "metricset.name",  
"order": {  
"\_count": "desc"  
},  
"size": 20  
}  
}  
},  
"size": 0,  
"\_source": {  
"excludes":   
},  
"stored\_fields": [  
"\*"  
],  
"script\_fields": {},  
"docvalue\_fields": [  
{  
"field": "@timestamp",  
"format": "date\_time"  
},  
{  
"field": "ceph.monitor\_health.last\_updated",  
"format": "date\_time"  
},  
{  
"field": "docker.container.created",  
"format": "date\_time"  
},  
{  
"field": "docker.healthcheck.event.end\_date",  
"format": "date\_time"  
},  
{  
"field": "docker.healthcheck.event.start\_date",  
"format": "date\_time"  
},  
{  
"field": "docker.image.created",  
"format": "date\_time"  
},  
{  
"field": "event.created",  
"format": "date\_time"  
},  
{  
"field": "event.end",  
"format": "date\_time"  
},  
{  
"field": "event.start",  
"format": "date\_time"  
},  
{  
"field": "file.accessed",  
"format": "date\_time"  
},  
{  
"field": "file.created",  
"format": "date\_time"  
},  
{  
"field": "file.ctime",  
"format": "date\_time"  
},  
{  
"field": "file.mtime",  
"format": "date\_time"  
},  
{  
"field": "kubernetes.container.start\_time",  
"format": "date\_time"  
},  
{  
"field": "kubernetes.event.metadata.timestamp.created",  
"format": "date\_time"  
},  
{  
"field": "kubernetes.event.timestamp.first\_occurrence",  
"format": "date\_time"  
},  
{  
"field": "kubernetes.event.timestamp.last\_occurrence",  
"format": "date\_time"  
},  
{  
"field": "kubernetes.node.start\_time",  
"format": "date\_time"  
},  
{  
"field": "kubernetes.pod.start\_time",  
"format": "date\_time"  
},  
{  
"field": "kubernetes.system.start\_time",  
"format": "date\_time"  
},  
{  
"field": "mongodb.replstatus.server\_date",  
"format": "date\_time"  
},  
{  
"field": "mongodb.status.background\_flushing.last\_finished",  
"format": "date\_time"  
},  
{  
"field": "mongodb.status.local\_time",  
"format": "date\_time"  
},  
{  
"field": "nats.server.time",  
"format": "date\_time"  
},  
{  
"field": "php\_fpm.pool.start\_time",  
"format": "date\_time"  
},  
{  
"field": "php\_fpm.process.start\_time",  
"format": "date\_time"  
},  
{  
"field": "postgresql.activity.backend\_start",  
"format": "date\_time"  
},  
{  
"field": "postgresql.activity.query\_start",  
"format": "date\_time"  
},  
{  
"field": "postgresql.activity.state\_change",  
"format": "date\_time"  
},  
{  
"field": "postgresql.activity.transaction\_start",  
"format": "date\_time"  
},  
{  
"field": "postgresql.bgwriter.stats\_reset",  
"format": "date\_time"  
},  
{  
"field": "postgresql.database.stats\_reset",  
"format": "date\_time"  
},  
{  
"field": "process.start",  
"format": "date\_time"  
},  
{  
"field": "system.process.cpu.start\_time",  
"format": "date\_time"  
},  
{  
"field": "zookeeper.server.version\_date",  
"format": "date\_time"  
}  
],  
"query": {  
"bool": {  
"must": ,  
"filter": [  
{  
"match\_all": {}  
},  
{  
"range": {  
"@timestamp": {  
"format": "strict\_date\_optional\_time",  
"gte": "2020-01-08T06:42:50.621Z",  
"lte": "2020-01-08T06:57:50.621Z"  
}  
}  
}  
],  
"should": ,  
"must\_not":   
}  
}  
}

I want to convert it to NEST. I tried like this but it now return empty

var elasticResponse =

```
            elasticClient.Search<object>(s => s

            .Aggregations(ag => ag.Terms("metricset.name", tr => tr.Order(o => o.Descending("_count"))))

            .Size(0)

            .DocValueFields(dvf => dvf.Fields(systemFields))

            .Query(q => q.Bool(bl => bl.Filter(fl => fl.Range(r => r.Field("@timestamp").GreaterThan(dd)))))

            );

```

I kept all DocValueFields in a string array.

---

<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:** [February 5, 2020, 9:48am UTC](https://discuss.elastic.co/t/need-to-convert-dsl-query-to-nest/214202/2 "2020-02-05T09:48:39Z")

</div>

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