[Dspace-tech] Moving items from one collection top another

2009-10-30 Thread John Preston
Can someone give me the sql to move an item from one collection to another. As I remeber it in an earlier DSpace incarnation it used to be possibl;e John -- Come build with us! The BlackBerry(R) Developer Conference in

Re: [Dspace-tech] Moving items from one collection top another

2009-10-30 Thread Claudia Juergen
Hello John, meanwhile there is a move item feature in DSpace. If you are using an older version, here is the sql with the usual warning (backup db etc. before manipulating it): update item set owning_collection=NewCollectionID where item_id=ItemID; update collection2item set