Number of restricted & open items in a community

31 views
Skip to first unread message

Joseph N. Sayah

unread,
Dec 16, 2019, 9:00:21 AM12/16/19
to DSpace Technical Support
Greetings,

How I can know the number of restricted items and the number of open items in a specific community.

P.S.: The version of DSPACE is 5.4 and the Database is Oracle

Best,

Joseph N. Sayah

unread,
Dec 16, 2019, 9:11:30 AM12/16/19
to DSpace Technical Support

José Geraldo

unread,
Dec 16, 2019, 9:51:47 AM12/16/19
to Joseph N. Sayah, DSpace Technical Support
Hi,

Make a join between the tables: community, collection, item and your associations.

Filter the column "discoverable = false" the item's table, to recover the privated itens.


--
All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
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 dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/04930937-759a-47e8-8a06-8c94e0b01897%40googlegroups.com.


--
At.te,

José Geraldo

Joseph N. Sayah

unread,
Dec 17, 2019, 1:23:00 AM12/17/19
to DSpace Technical Support

Restricted_Item.jpg


Open_Item.jpg

Hi José ,

Thank you so much for your reply, what I want is not public or private, this field discover-able will show me if the item is private or public, but what I want is if it's a restricted item or an open item, for more details please see above images, the first one is for restricted item and the second image is for open item.

Best,



On Monday, December 16, 2019 at 4:51:47 PM UTC+2, José Geraldo wrote:
Hi,

Make a join between the tables: community, collection, item and your associations.

Filter the column "discoverable = false" the item's table, to recover the privated itens.


Em seg., 16 de dez. de 2019 às 11:11, Joseph N. Sayah <joseph...@gmail.com> escreveu:


On Monday, December 16, 2019 at 4:00:21 PM UTC+2, Joseph N. Sayah wrote:
Greetings,

How I can know the number of restricted items and the number of open items in a specific community.

P.S.: The version of DSPACE is 5.4 and the Database is Oracle

Best,

--
All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
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 dspac...@googlegroups.com.


--
At.te,

José Geraldo

Joseph N. Sayah

unread,
Dec 17, 2019, 1:27:50 AM12/17/19
to DSpace Technical Support
Hi José ,

I am sorry, I think my inquiry was not clear enough, I need to know the number of the restricted files and open files that are related to a collections' items. 

Best,
Reply all
Reply to author
Forward
0 new messages