After half day looking around I figure out that the table HANDLE contains the data:
*select * from handle where handle = '123456789/2707;* I had to ask the question to figure it out!! Thanks and regards! On Thursday, May 4, 2017 at 12:24:58 PM UTC-3, [email protected] wrote: > > Hi, > > I have an installation of DSPACE 5.X with a lot of communities and > collections. Some collections have the same name, so when I retrieve all > the data from the REST /collections > <https://jspace.atlassian.net/wiki/display/DSPACEAPI/GET_collections> I'm > having trouble ensuring that the id correspond to the collection. > > So I thought that a good way to check that is using the URL of the page to > find out the collection id. > > I have this URL */handle/123456789/2707* and I know it has the id 40 on > the table *collection *using the query: select * from metadatavalue where > resource_type_id = 3; I can see all the names. > > But I can't figure out how to match the 2707 to the id collection? Where > is stored the 2707? I'm searching the schema on > https://wiki.duraspace.org/display/DSDOC5x/Storage+Layer but I can't > figure it out. > > Thanks in advance for any help! > > Regards! > > Rodrigo > -- 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.
