Hi, as far as I remember the 'THUMBNAIL' bundle is also generated by a filter-media run (it contains small jpgs to display on a browse page). Do you want to count them too or only user submitted files ?
Kate Ekaterina Pechekhonova Digital Library Programmer/Analyst New York University Libraries email: [EMAIL PROTECTED] phone: 212-992-9993 ----- Original Message ----- From: Jose Blanco <[EMAIL PROTECTED]> Date: Wednesday, April 25, 2007 11:41 am Subject: [Dspace-tech] counting bitstreams in an item To: dspace-tech@lists.sourceforge.net > Most of our items just contain pdf files, but not all, and I'm writing > a > script that counts the number of bitstreams in each item. The numbers > I'm > getting don't look quite right. The SQL I'm using to compute the > number of > items in an item is: > > > > select count(*) from bundle B, item2bundle IB, Bundle2Bitstream BB, > Bitstream Bi where Bi.bitstream_id = BB.bitstream_id and IB.bundle_id > = > BB.bundle_id and B.bundle_id = IB.bundle_id and IB.item_id = $item_id > and > (B.name = 'ORIGINAL' or B.name='THUMBNAIL' ) > > > > where $item_id is the item_id I'm counting for. > > > > I don't want to count the license file, or the txt file that gets created > when filter-media runs - just the items that the user deposited. Can > some > one confirm if this SQL is correct? > > > > Many thanks! > > > > Jose > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech