Re: [Dspace-tech] SQL query to count number of downloadables (bitstream)

2015-01-23 Thread euler
Hello Helix, Thanks for this. It did returned me the number of bitstreams. I wonder if it's possible to generate a list of these bitstreams? In previous dspace versions, I would just import the bitstream table into ms access and do the filtering (e.g. filter by selection with filenames ending in

Re: [Dspace-tech] SQL query to count number of downloadables (bitstream)

2015-01-23 Thread helix84
Hi Euler, try this query. I haven't tested it much, but it should give you the idea how this works in DSpace 5. This reminds me we should also update the ER-diagram in documentation. SELECT count(1)FROM bundle2bitstreamINNER JOIN metadatavalue ON bitstream_id = resource_id WHERE

[Dspace-tech] SQL query to count number of downloadables (bitstream)

2015-01-20 Thread euler
Dear All, I would like to ask for your help regarding in generating an SQL query. I'm using DSpace 5 and I've noticed there were changes in the bitstream table particularly the bitstream's file name is not there. How can I generate a list for all the bitstreams with a pdf file extension and file