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%2BxAuhM%2BKFwn5tVcmtWByLaAT-GAgYF-ZoOL75ybYS6x1DasyQ%40mail.gmail.com.

Reply via email to