It should be also helpful to know the bitstream name in addition to item handle:
SELECT DISTINCT handle.handle_id, bitstream.name FROM bitstream,bundle2bitstream,item2bundle,bundle,handle WHERE handle.resource_id=item2bundle.item_id AND item2bundle.bundle_id=bundle2bitstream.bundle_id AND bundle2bitstream.bitstream_id=bitstream.bitstream_id AND bitstream.internal_id='30837199014132132506155472754588837323'; Regards, ~~helix84 ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
