Re: [Dspace-tech] Identifying items with and without bitstream

2013-07-16 Thread Terry Brady
The following SQL will return items without an original bitstream. Remove the line and b.name = 'ORIGINAL' to find items with no bitstreams at all. If you are not using postgres, you may need to modify the command to format the title. Terry select h.handle,

[Dspace-tech] Identifying items with and without bitstream

2013-07-09 Thread Tint Hla Hla Htoo
Hello In our repository, several items are metadata only - no bitstreams. Now we would like to know which items are with bitstreams and which are not. Appreciate it very much if someone could tell me how I can get a list of item-ids for items with bitstreams and a list without. Thanks. Tint