I found out that the query was required to go from item:
dspaceobject -> item -> item2bundle -> bundle -> bundle2bitstream -> bitstream SELECT * FROM bitstream as z JOIN (select bitstream_id from bundle2bitstream as b2b JOIN (select a.bundle_id from item2bundle a JOIN item b ON a.item_id=b.uuid where b.uuid = '4e203020-8fd6-406a-addc-f4f08365b662') as i2b ON b2b.bundle_id =i2b.bundle_id) as y ON z.uuid= y.bitstream_id On Monday, August 29, 2022 at 4:52:42 PM UTC-4 Tianyi Gu wrote: > Hello everyone, > > I installed the DSpace docker and ingested entity test data. > > I was trying to figure out how items connect with bitstream in one query. > But I found Primary_bitstream_id and Bundle_id were null values. > > Please advise. > > Thank you, > Tianyi > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- 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/83f5856c-a1ce-487e-907d-d58547d4aad7n%40googlegroups.com.
