Elastic Search : Mapping date format and sort by date
While working on the job board for Socketloop.com recently, I need to sort the Elastic Search result based on the date when the entry is created.
Before the sorting part can happen, first the mappings need to be configured with the type "date" with a proper formatting.
"postDate": {"type": "date", "format" : "yyyy-MM-dd HH:mm:ss"}
and below is a snippet from the Elastic Search mapping.
"mappings" : {
"people": {
"properties": {
"username": {"type": "string"},
"postDate": {"type": "date", "format" : "yyyy-MM-dd HH:mm:ss"}
}
}
and add the 'sort' section in my Elastic Search query
$searchquery = '{
"size" : 9999,
"sort" : [
{ "postDate" : {"order" : "desc"}}
]
}';
and the result be seen at https://profession.socketloop.com/people (still pretty new and not many records to sort for the moment - March 2015)
Reference :
http://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html
See also : PHP : How to parse ElasticSearch JSON ?
By Adam Ng
IF you gain some knowledge or the information here solved your programming problem. Please consider donating to the less fortunate or some charities that you like. Apart from donation, planting trees, volunteering or reducing your carbon footprint will be great too.
Advertisement
Tutorials
+8.8k Golang : Check if user agent is a robot or crawler example
+7.9k Golang : What is the default port number for connecting to MySQL/MariaDB database ?
+8.4k Golang : Quadratic example
+7.8k Golang : Handle sub domain with Gin
+16.5k Golang : Aligning strings to right, left and center with fill example
+9.4k Golang : ISO8601 Duration Parser example
+26k Golang : Convert integer to binary, octal, hexadecimal and back to integer
+18k Mac OSX : Homebrew and Golang
+3.9k JQuery : Calling a function inside Jquery(document) block
+32.7k Golang : convert(cast) bytes to string
+9.7k Golang : Simple image viewer with Go-GTK
+16.1k Golang : Iterate linked list example