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. https://wiki.lyrasis.org/display/DSDOC5x/Storage+Layer?preview=/45548226/68355659/dspace5.png Em seg., 16 de dez. de 2019 às 11:11, Joseph N. Sayah < [email protected]> 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/dspace-tech/04930937-759a-47e8-8a06-8c94e0b01897%40googlegroups.com > <https://groups.google.com/d/msgid/dspace-tech/04930937-759a-47e8-8a06-8c94e0b01897%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- At.te, José Geraldo -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CANP4ikRZ5x65EvN%2BjUYky%2BLxBRTC%3DzpRWB85Ou6OH7tSWjPh%2Bg%40mail.gmail.com.
