Hello, a simple way to update metadata is using the "export metadata" (UI) from a collection to csv, edit the csv file and reimport this. But you could create a function collection2items alike the other functions, too. For example:
CREATE OR REPLACE FUNCTION ds6_collectionhandle2item (varchar) RETURNS setof uuid AS 'SELECT item_id FROM collection2item WHERE collection2item.collection_id = ( SELECT resource_id FROM handle WHERE handle.resource_type_id = 3 AND handle = $1)' LANGUAGE SQL STABLE RETURNS NULL ON NULL INPUT; Best regards, Paul Am 11.01.2018 um 10:15 schrieb [email protected]: > Hello, > > > I have a question is there any way to retrieve field like > "dc.description.citation" from all items in specific collection ? > I need to update that field and other one with not static information, > thats why I would refer a way in SQL. > > https://wiki.duraspace.org/display/DSPACE/Helper+SQL+functions+for+DSpace+6 > , found these helpers but I don't see any for collection2items function :/ > > OS: Debian > Dspace: 6.2 > Postgres: 9.4.1 > > > Thanks for any advice :) > -- > You received this message because you are subscribed to the Google > Groups "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. -- Philipps-Universität Marburg | UB Digitale Dienste | Wilhelm-Röpke-Straße 6 | 08A09 Tel. 06421/28-24624 | -- -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
signature.asc
Description: OpenPGP digital signature
