|
||||||||
|
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, author.text_value, title.text_value, unit.text_value, series.text_value FROM metadatavalue AS date,
metadatafieldregistry AS dater,
metadatavalue AS uri,
metadatafieldregistry AS urir,
metadatavalue AS title,
metadatafieldregistry AS titler,
metadatavalue AS author,
metadatafieldregistry AS authorr,
metadatavalue AS unit,
metadatafieldregistry AS unitr,
metadatavalue AS series,
metadatafieldregistry AS seriesr,
item
WHERE
item.in_archive = 't'
AND item.withdrawn = 'f'
AND 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'
AND title.item_id = item.item_id
AND title.metadata_field_id = titler.metadata_field_id
AND titler.element = 'title'
AND author.item_id = item.item_id
AND author.metadata_field_id = authorr.metadata_field_id
AND authorr.element = 'contributor'
AND authorr.qualifier = 'author'
AND unit.item_id = item.item_id
AND unit.metadata_field_id = unitr.metadata_field_id
AND unitr.element = 'contributor'
AND unitr.qualifier = 'unit'
AND unit.text_value = 'Centre for Accounting, Governance and Taxation Research'
AND series.item_id = item.item_id
AND series.metadata_field_id = seriesr.metadata_field_id
AND seriesr.element = 'relation'
AND seriesr.qualifier = 'ispartofseries'
ORDER BY date.text_value
;