[image: Restricted_Item.jpg]
[image: 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. > > > 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 <joseph...@gmail.com > <javascript:>> 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 <javascript:>. >> 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 dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/6becffdc-d2db-43bc-a88e-ea00db9f2129%40googlegroups.com.
