Thanks, Helix. El dilluns, 12 desembre de 2016 17:22:45 UTC+1, helix84 va escriure: > > 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 <angels...@gmail.com > <javascript:>> 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 dspace-tech...@googlegroups.com <javascript:>. >> To post to this group, send email to dspac...@googlegroups.com >> <javascript:>. >> 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
