Title: Message Title
|
|
|
|
Here is some SQL to find items with duplicate values for dc.date.issued and dc.date.accessioned. First, the PostgreSQL version:
SELECT item_id
FROM METADATAVALUE a JOIN METADATAVALUE b USING (item_id)
WHERE a.metadata_field_id = 11
AND b.metadata_field_id = 15
AND a.text_value = b.text_value
and now the Oracle version:
SELECT item_id
FROM METADATAVALUE a JOIN METADATAVALUE b USING (ITEM_ID)
WHERE
a.metadata_field_id = 11
AND b.metadata_field_id = 15
AND dbms_lob.compare(a.text_value, b.text_value) = 0
This returns 50 items for the MOspace repository.
|
|
|
|
|
|
|
Google (Anurag Acharya and Darcy Darpa) has contacted DuraSpace about a common indexing issue affecting all DSpace sites.
When Google & Google Scholar index DSpace content (from a variety of institutions), the "dc.date.issued" value is incorrect the majority of the time. The reason is that, if unspecified, DSpace sets this issued date to the *date of a...
|
|
|
|
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel
