yes, look only in the 'ORIGINAL' bundle 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 2:31 pm Subject: Re: [Dspace-tech] counting bitstreams in an item To: 'Ekaterina Pechekhonova' <[EMAIL PROTECTED]> Cc: [email protected] > Only the submitted Item, so I should just check for ORIGINAL? Is that > what > ORIGINAL means? > > Thanks for taking this question? I was not sure what THUMBNAIL meant. > > -Jose > -----Original Message----- > From: Ekaterina Pechekhonova [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 25, 2007 2:28 PM > To: Jose Blanco > Cc: [email protected] > Subject: Re: [Dspace-tech] counting bitstreams in an item > > 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: [email protected] > > > 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 > > [email protected] > > 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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
