Thank you Tim, > My guess would be that you may need to reindex. Since you moved the > objects manually in the database tables, the browse/search indexes may > not be fully aware of the move. Assuming you are using Discovery, you'd > likely need to run > > [dspace]/bin/dspace index-discovery -b
That did it. Out of mere curiosity, where are the indexes stored? > In the future, if you ever encounter the need to move items between > Collections, I'd recommend using the Batch Metadata Editing tool. It has > the ability to change the Collection(s) associated with any Items, and > it will also automatically trigger a reindex for any item updates. The > information on changing a Collection in the Batch Metadata Editing tool > is here: > > https://wiki.duraspace.org/display/DSDOC4x/Batch+Metadata+Editing#BatchMetadataEditing-EditingCollectionMembership But does that allow complexs SQL request to select the list of items that will be modified? By complex I mean something like this: update item set owning_collection= 98 where item_id in ( select collection2item.item_id from collection2item, metadatavalue where collection2item.item_id=metadatavalue.item_id and metadata_field_id=24 and collection_id=60 and text_value not like '%IM-%' ) Best regards, Olivier > > - Tim > > > On 5/13/2015 4:58 AM, Olivier Nicole wrote: >> Hello, >> >> I have a large number of items that ended up in the wrong collection. >> >> One of the metadata attached to each item will allow me to sort them >> out, but I need to move the items around in the database. >> >> I have seen that the tables item and collection2item both associate an >> item with a collection. But modifying the collection id in these tables >> is not enough. >> >> The item is now listed like it belongs where it should, but when listing >> the wrong cllection, the item is still shown there. >> >> How can I rectify this? is that a cache or a table I am overlooking? >> >> DSpace 4.2 >> >> Many thanks in advance, >> >> Olivier >> > > ------------------------------------------------------------------------------ > One dashboard for servers and applications across Physical-Virtual-Cloud > Widest out-of-the-box monitoring support with 50+ applications > Performance metrics, stats and reports that give you Actionable Insights > Deep dive visibility with transaction tracing using APM Insight. > http://ad.doubleclick.net/ddm/clk/290420510;117567292;y > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > -- ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette