# Sorting Issue In Discoverer Kibana

**URL:** https://discuss.elastic.co/t/sorting-issue-in-discoverer-kibana/168048
**Category:** Kibana
**Created:** [February 12, 2019, 2:27pm UTC](https://discuss.elastic.co/t/sorting-issue-in-discoverer-kibana/168048 "2019-02-12T14:27:14Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![sayantani](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@sayantani](https://discuss.elastic.co/u/sayantani)
#### Post date: [February 12, 2019, 2:27pm UTC](https://discuss.elastic.co/t/sorting-issue-in-discoverer-kibana/168048/1 "2019-02-12T14:27:14Z")

</div>

Hi,

we have a property startTime under event and this property is type of date. In the discoverer, when we sort by startTime , data is not getting sorted properly.  
Could you please help us on this?

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

---

<div class="post-metadata">

### Author: ![jen-huang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jen-huang/32/74327_2.png) [@jen-huang](https://discuss.elastic.co/u/jen-huang)
#### Post date: [February 12, 2019, 7:54pm UTC](https://discuss.elastic.co/t/sorting-issue-in-discoverer-kibana/168048/2 "2019-02-12T19:54:47Z")

</div>

Hi, could you please share the ES mapping for this index pattern? You can do in Dev Tools and send `GET /your_index_pattern*/_mapping`.

---

<div class="post-metadata">

### Author: ![sayantani](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@sayantani](https://discuss.elastic.co/u/sayantani)
#### Post date: [February 13, 2019, 2:50pm UTC](https://discuss.elastic.co/t/sorting-issue-in-discoverer-kibana/168048/3 "2019-02-13T14:50:59Z")

</div>

{"cwl-2019.02.11":{"mappings":{"plt-coresvcs-dev-use1a-esindex":{"properties":{"$event":{"properties":{"ETag":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Key":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"LastModified":{"type":"date"},"Owner":{"properties":{"DisplayName":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"ID":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}},"Size":{"type":"long"},"StorageClass":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"activityScheduledEventDetails":{"properties":{"input":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"resource":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}},"author":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"body":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"endTime":{"type":"date"},"endtimestamp":{"type":"date"},"errorDescription":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"errorMessage":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"fileName":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"header":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"headers":{"properties":{"Accept":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Accept-Encoding":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Accept-Language":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Forwarded-Proto":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Is-Desktop-Viewer":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Is-Mobile-Viewer":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Is-SmartTV-Viewer":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Is-Tablet-Viewer":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Viewer-Country":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Content-Type":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Host":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"User-Agent":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Via":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Amz-Cf-Id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Amzn-Trace-Id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Forwarded-For":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Forwarded-Port":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Forwarded-Proto":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"content-type":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"origin":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}},"httpMethod":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"input":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"isBase64Encoded":{"type":"boolean"},"messageId":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"messageInfo":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"msg":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"msgId":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"multiValueHeaders":{"properties":{"Accept":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Accept-Encoding":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Accept-Language":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Forwarded-Proto":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Is-Desktop-Viewer":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Is-Mobile-Viewer":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Is-SmartTV-Viewer":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Is-Tablet-Viewer":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"CloudFront-Viewer-Country":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Content-Type":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Host":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"User-Agent":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"Via":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Amz-Cf-Id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Amzn-Trace-Id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Forwarded-For":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Forwarded-Port":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"X-Forwarded-Proto":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"content-type":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"origin":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}},"path":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"previousEventId":{"type":"long"},"requestContext":{"properties":{"accountId":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"apiId":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"domainName":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"domainPrefix":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"extendedRequestId":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"httpMethod":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"identity":{"properties":{"sourceIp":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"userAgent":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}},"path":{"type":"text","fields":{"keyword":

---

<div class="post-metadata">

### Author: ![sayantani](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@sayantani](https://discuss.elastic.co/u/sayantani)
#### Post date: [February 13, 2019, 2:51pm UTC](https://discuss.elastic.co/t/sorting-issue-in-discoverer-kibana/168048/4 "2019-02-13T14:51:09Z")

</div>

{"type":"keyword","ignore\_above":256}}},"protocol":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"requestId":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"requestTime":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"requestTimeEpoch":{"type":"long"},"resourceId":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"resourcePath":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"stage":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}},"resource":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"serviceSource":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"source":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"src":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"stage":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"startTime":{"type":"date"},"stateExitedEventDetails":{"properties":{"name":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"output":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}},"status":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"taskToken":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"timestamp":{"type":"date"},"type":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}}}},"@id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"@log\_group":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"@log\_stream":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"@message":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"@owner":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"@timestamp":{"type":"date"},"event":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"request\_id":{"type":"text","fields":{"keyword":{"type":"keyword","ignore\_above":256}}},"timestamp":{"type":"date"}}}}}}

---

<div class="post-metadata">

### Author: ![sayantani](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@sayantani](https://discuss.elastic.co/u/sayantani)
#### Post date: [February 13, 2019, 2:52pm UTC](https://discuss.elastic.co/t/sorting-issue-in-discoverer-kibana/168048/5 "2019-02-13T14:52:25Z")

</div>

Thank you for your response.  
I was not able to send entire json response because of the limitation in this UI. I have sent in 2 post, if you copy both the post together , that will be the entire response for the mapping query.  
Please let me know if this helps.

---

<div class="post-metadata">

### Author: ![sayantani](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@sayantani](https://discuss.elastic.co/u/sayantani)
#### Post date: [February 15, 2019, 4:36pm UTC](https://discuss.elastic.co/t/sorting-issue-in-discoverer-kibana/168048/6 "2019-02-15T16:36:48Z")

</div>

Hi,

Could anyone please help on this issue?

---

<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 15, 2019, 4:41pm UTC](https://discuss.elastic.co/t/sorting-issue-in-discoverer-kibana/168048/7 "2019-03-15T16:41:58Z")

</div>

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