On Thu, Aug 6, 2009 at 6:41 PM, Chantal Ackermann<chantal.ackerm...@btelligent.de> wrote: > Hi again, > > 1.4 runs fine for me, now, but I'm still struggling for the correct delete > query. There is few to no documentation at all for the new special commands, > and I have problems guessing the correct setup from reading through the > code. SORL-1060 is not enough help. > > I've come up with a separate entity for issueing the deletes - is that how > it should be done? How can I make sure that these deletes are issued before > the other entities are processed? Is it enough to put it as first entity in > the config? this is a better solution > > <entity name="delete_from_index" pk="GROUPID" > query="select GROUPID from DEFINITION > where LANGUAGE='de' > and CHANGED_DATE > '${dataimporter.last_index_time}'"> > <field column="$deleteDocByQuery" > query="groupid:${delete_from_index.GROUPID}"/> > </entity> > > I am not sure about which attributes to use for the "field" element when > using that special command. I've put the query in with attribute "query" > which is probably not right because I just wrote it down like that. Should I > use the "name" attribute as done for the regular fields? Do I need to add a > $skipDoc command (like it's mentioned in SOLR-1060)?
<entity name="delete_from_index" pk="GROUPID" transformer="TemplateTransformer" query="select GROUPID from DEFINITION where LANGUAGE='de' and CHANGED_DATE > '${dataimporter.last_index_time}'" > <field column="$deleteDocByQuery" template="groupid:${delete_from_index.GROUPID}"/> </entity> this should do the trick > > Thanks! > Chantal > > > > Chantal Ackermann schrieb: >> >> Thanks, Paul! :-) >> >> The wiki doesn't mark $deleteDocByQuery (and the other special commands) >> as 1.4, as it usually does. Maybe it's worth correcting that? >> >> Noble Paul നോബിള് नोब्ळ् schrieb: >>> >>> ok, writing an EntityProcessor/Transofrmer may help here use the special >>> command >>> >>> http://wiki.apache.org/solr/DataImportHandler#head-5e9ebf5a2aaa1dc54464102c395ed1bf7cdb98c3 >>> >>> $deleteDocByQuery is what you need . >>> > -- ----------------------------------------------------- Noble Paul | Principal Engineer| AOL | http://aol.com