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 pdf). With the dspace 5 version, I can't find the table where the filenames were saved.
Thanks again for your help, I needed the figures for our annual report. Regards, euler -- View this message in context: http://dspace.2283337.n4.nabble.com/SQL-query-to-count-number-of-downloadables-bitstream-tp4676287p4676368.html Sent from the DSpace - Tech mailing list archive at Nabble.com. ------------------------------------------------------------------------------ New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette