Hi Sean, Yes, i using DSpace 6.3, thank You for helping. I tried this: SELECT * FROM community; and i see:
community_id | uuid | 9 | sdsd343241535454 | great, but, how can i corelate uuid with name of communitys/collections? Community_id is the number after domain name https://repozytorium.amu.edu.pl/10593/*9 *? Thank You, Karol czwartek, 9 czerwca 2022 o 09:46:40 UTC+2 [email protected] napisał(a): > For DSpace 6: > > SELECT community_id, uuid, text_value > FROM community co, metadatavalue mv > WHERE co.uuid = dspace_object_id; > > SELECT collection_id, uuid, text_value > > FROM collection co, metadatavalue mv > WHERE co.uuid = dspace_object_id; > > Sean > > On Thu, 9 Jun 2022 at 09:27, Sean Carte <[email protected]> wrote: > >> Hi Karol >> >> I think the easiest way to find the ID (or uuid in 6+) is to query the >> database: >> >> SELECT * FROM collection; >> >> You haven't said what version of DSpace you are using, but for DSpace 5, >> you could do this: >> >> SELECT >> co.collection_id, mv.resource_id, mv.text_value >> FROM collection co, metadatavalue mv >> WHERE co.collection_id = mv.resource_id >> AND mv.resource_type_id = 3; >> >> That won't work in DSpace 6 as there is no resource_type_id field anymore. >> >> For communities: >> >> SELECT * FROM community; >> >> SELECT >> cm.community_id, mv.resource_id, mv.text_value >> FROM community cm, metadatavalue mv >> WHERE cm.community_id = mv.resource_id >> AND mv.resource_type_id = 4; >> >> Sean >> >> Karol Sokalski <[email protected]>: Jun 08 04:17AM -0700 >>> >>> Hi Sean, >>> >>> where i can find owningColl number for collections and Communities?: >>> /solr/statistics/select?q=type:0+*owningColl:9* >>> >>> +isBot:false+time:[2017-06-01T00:00:00Z+TO+2017-07-01T00:00:00Z]&fq=-(bundleName:[*+TO+*]-bundleName:ORIGINAL)&indent=on&rows=0 >>> Thanks, >>> >>> Karol >>> >> -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/387caade-ec07-4229-a6b8-b791fdeb5c70n%40googlegroups.com.
