To select all items for a field in Solr you can use the query : some_item:[* TO *], but if this field is missing from some documents you will not select those documents.

To select all documents you can use the id defined in /conf/schema.xml, for example: <uniqueKey>solr_id</uniqueKey> you can use solr_id:[* TO *].

Now that you have all documents selected you can delete them :D

To delete all documents in Solr use this update xml:

<delete><query>solr_id:[*TO *]</query></delete>

and of course you have to commit:

<commit />

That’s all !

 

 

2 responses to “Select/delete all items in Solr

  1. To get all results using acts_as_solr’s find_by_solr (not deleting, just searching), I found “type:[* TO *]” worked fine across all models, though “id:[* TO *]” didn’t. Thanks!

Leave a Comment:

Your email address will not be published. Required fields are marked *