Move item between collections

From UFP-UV Sakai Wiki

Jump to: navigation, search


Move between collections

Need to replace values below!!!

-- find destination collection_id
SELECT collection_id,name FROM collection WHERE name LIKE '%FCHS%';
-- find internal id of the item
SELECT handle, resource_id FROM handle WHERE handle='10284/1422';
-- update it! (1550 is the item internal id, 47 the destination collection id)
UPDATE item SET owning_collection=47 WHERE item_id IN (1550);
UPDATE collection2item SET collection_id=47 WHERE item_id IN (1550);
Personal tools