sql_querry_find_all_dates_for_item2.text
Date HTML Created
08 Sep 2008
select item_id , text_value, element, qualifier , scope_note from metadatavalue inner join metadatafieldregistry on metadatavalue.metadata_field_id = metadatafieldregistry.metadata_field_id where item_id=2 order by metadatavalue.metadata_field_id;
item_id | text_value | element | qualifier | scope_note
---------+------------------------------------------------------------------------------+-------------+-------------+----------------------------------------------------------------------------------------------------------------
2 | Liu, C. | contributor | author |
2 | 2007-12-13T22:53:15Z | date | accessioned | Date DSpace takes possession of item.
2 | 2007-12-13T22:53:15Z | date | available | Date or date range item became available to the public.
2 | 1994-07 | date | issued | Date of publication or distribution.
2 | 1259 | identifier | | Catch-all for unambiguous identifiers not defined by
: qualified form; use identifier.other for a known identifier common
: to a local collection instead of unqualified form.
2 | http://odin.lib.umn.edu/purl/2204 | identifier | uri | Uniform Resource Identifier
2 | Made available in DSpace on 2007-12-13T22:53:15Z (GMT). No. of bitstreams: 1 | description | provenance | The history of custody of the item since its creation, including any changes successive custodians made to it.
: 1259.pdf: 1562927 bytes, checksum: 8d10fd3af05f8f9a89825683a7c81086 (MD5)
: Previous issue date: 1994-07
2 | Institute for Mathematics and Its Applications>IMA Preprints Series | relation | | Catch-all for references to other related items.
2 | xponentially growing solutions for inverse problems in PDE | title | | Title statement/title proper.
(9 rows)