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, On Tuesday, December 17, 2019 at 8:23:00 AM UTC+2, Joseph N. Sayah wrote: > > [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 < >> [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/258d093a-198a-417f-a8be-5f3c1e87e715%40googlegroups.com.
