Hey Run this query
select metadata_field_id, element from metadatafieldregistry where element = 'firstname' or element = 'lastname'; Now this will give you the metadata_field_id of the firstname and lastname which we will use to run the following query on a certain individual. select text_value as firstname, (select text_value as lastname from metadatavalue where metadata_field_id = '*lastname_metadata_field_id*' and resource_id = '*eperson_id*') from metadatavalue where metadata_field_id = '*firstname_metadata_field_id*' and resource_id = '*eperson_id*'; Replace the following in the below query: *firstname_metadata_field_id* : which is the metadata_field_id of the firstname element. *lastname_metadata_field_id : *which is the metadata_field_id of the lastname element. *eperson_id : *which is the eperson_id of the certain individual you are targeting. Hope that makes sense Thank you On Monday, 23 May 2016 22:35:51 UTC+2, Tom Avino wrote: > > Does someone have a list of the dspace 5.5 postgres schema? > > What specific postgres database changes were made from 3.3 to 5.5? > > Other tables seem wrong. metadatavalue no longer contains item_id > -- 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.
