|
||||||||
|
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira |
||||||||
------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________ Dspace-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-devel
SELECT
date.text_value, uri.text_value FROM metadatavalue AS date,
metadatafieldregistry AS dater,
metadatavalue AS uri,
metadatafieldregistry AS urir,
item
WHERE date.item_id = item.item_id
AND date.metadata_field_id = dater.metadata_field_id
AND dater.element = 'date'
AND dater.qualifier = 'copyright'
AND uri.item_id = item.item_id
AND uri.metadata_field_id = urir.metadata_field_id
AND urir.element = 'identifier'
AND urir.qualifier = 'uri'
ORDER BY date.text_value
;