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/CA%2BxAuhM29-qrDAdEjbCLMXYAZCS1x0cg8sX%2ByTWALL3YoDxQuQ%40mail.gmail.com.
