If you want to do this as a single delete-by-query, you could OR all
the clauses together:
<delete><query>load_id:(20070424150841 OR 20070425145301 .... )</
query></delete>
Erik
On May 1, 2007, at 2:14 AM, Ryan McKinley wrote:
escher2k wrote:
I am trying to remove documents from my index using "delete by
query".
However when I did this, the deleted
items seem to remain. This is the format of the XML file I am using -
<delete><query>load_id:20070424150841</query></delete>
<delete><query>load_id:20070425145301</query></delete>
<delete><query>load_id:20070426145301</query></delete>
<delete><query>load_id:20070427145302</query></delete>
<delete><query>load_id:20070428145301</query></delete>
<delete><query>load_id:20070429145301</query></delete>
When I do the deletes individually, it seems to work (i.e. create
each of
the above in a separate file). Does this
mean that each delete query request has to be executed separately ?
correct, delete (unlike <add>) only accepts one command.
Just to note, if "load_id" is your unique key, you could also use:
<delete><id>20070424150841</id></delete>
This will give you better performance and does not commit the
changes until you explicitly send <commit/>
