Start with this: SELECT text_value AS dc_date_accessionedFROM metadatavalueWHERE metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry, metadataschemaregistry WHERE metadatafieldregistry.metadata_schema_id = metadataschemaregistry.metadata_schema_id AND short_id = 'dc' AND element = 'date' AND qualifier = 'accessioned') LIMIT 50;
See also: https://wiki.duraspace.org/display/DSPACE/Helper+SQL+functions+for+DSpace+5 https://wiki.duraspace.org/display/DSDOC5x/Storage+Layer#StorageLayer-RDBMS/DatabaseStructure Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette On Mon, Dec 12, 2016 at 5:10 PM, Mariangels <[email protected]> wrote: > Hello, > We are working with DSpace 5.5. > We need a total report (all our records) from the DSpace's database > showing all those fields: > > dc.date.accesioned > dc.rights.accesRights > dc.type > dc.identifier.uri > and the main community > > How can I ask the database for get this information? > > Thaks in advance. > > *I tried to do with .csv but it is difficult because the system show 3 or > more columns for each field!!! Like this: > dc.rights.accesRights[]#dc.rights.accesRights[ca_ES]#dc. > rights.accesRights[en_US]#dc.rights.accesRights[es] > > -- > You received this message because you are subscribed to the Google Groups > "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
