Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to get last indexed record in Solr?

I want to know how to get/search last indexed record in Apache Solr..?

When the existing record is updated then it goes to end of all the records...so I want to get that last indexed record.

thanks..

like image 763
milind_db Avatar asked Sep 10 '12 06:09

milind_db


2 Answers

You could add a 'timestamp' field to your Solr schema that puts the current date/time into the record when it is added.

<field name="timestamp" type="date" indexed="true" stored="true" default="NOW" multiValued="false"/>

Then, do a sort in descending order by this field and the first record will be the latest one. A query like this should do it:-

http://localhost:8080/solr/core-name/select/q=*%3A*&start=0&rows=1&sort=timestamp+desc

like image 70
prunge Avatar answered Sep 27 '22 22:09

prunge


You can sort the documents by the indexed order using the following query.

http://localhost:8983/solr/select?q=*:*&sort=_docid_ asc

or 

http://localhost:8983/solr/select?q=*:*&sort=_docid_ desc
like image 28
Parvin Gasimzade Avatar answered Sep 27 '22 22:09

Parvin Gasimzade