Hi Olivier, 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 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 - 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