As pointed out by Claudia Juergen, this will only work if you don't have
any qualified versions of dc.type (eg: dc.type.publicationtype). If you
do have such qualifications, you'll need to make sure that the qualifier
is null by adding something like:
AND mfr.qualifier IS NULL
to the nested query.
Jim
On Thu, Mar 01, 2007 at 05:32:35PM +0000, James Rutherford wrote:
> Hi,
>
> On Thu, Mar 01, 2007 at 05:22:42PM +0100, Obiajulu Odu wrote:
> > I would like to update all the dc.type values in all items in our system
> > from "Doctoral Thesis" to "PhD". How can I do that in DSpace 1.4. at the
> > postgresql level.
>
> Before I say anything else, I'm going to insist that you run this on a
> test instance first to make sure you get sensible results. I'm not going
> to be held responsible if this falls over ;)
>
> Something like this ought to do it (assuming you're running DSpace >=
> 1.4; if you're running 1.3.2 or earlier, this won't work):
>
> UPDATE metadatavalue
> SET text_value='PhD'
> WHERE metadata_value_id IN
> (
> SELECT metadata_value_id
> FROM metadatavalue mv,
> metadatafieldregistry mfr,
> metadataschemaregistry msr
> WHERE mv.metadata_field_id = mfr.metadata_field_id
> AND mfr.metadata_schema_id = msr.metadata_schema_id
> AND mfr.element = 'type'
> AND msr.short_id = 'dc'
> );
>
> However, you should first check that this gives a sensible set of
> records to update on your repository by running the nested query:
>
> SELECT *
> FROM metadatavalue mv,
> metadatafieldregistry mfr,
> metadataschemaregistry msr
> WHERE mv.metadata_field_id = mfr.metadata_field_id
> AND mfr.metadata_schema_id = msr.metadata_schema_id
> AND mfr.element = 'type';
> AND msr.short_id = 'dc'
>
> Cheers,
>
> Jim
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
