Hi Susan, then you got to use something like:
select count(b.bundle_id) from bundle b, item2bundle i2b, item i where b.name='TEXT' and b.bundle_id=i2b.bundle_id and i2b.item_id=i.item_id and i.in_archive=true; The bundle are: ORIGINAL - original, deposited bitstreams THUMBNAILS - thumbnails of any image bitstreams TEXT - extracted full-text from bitstreams in ORIGINAL, for indexing LICENSE - the deposit license CC_LICENSE - the distribution license, if Creative Commons is used Claudia Susan Parham schrieb: > Basically, the number of items which are full-text searchable - it > doesn't matter if the original content is pdf, doc, etc. This is why > I was going for the items with that .txt file which is created by > media filter. We may have some older pdfs which are not OCR'd, and > would then not have the .txt file. We don't have any items which > consist solely of metadata. > > Susan > > On Tue, Aug 12, 2008 at 3:12 PM, Claudia Juergen > <[EMAIL PROTECTED]> wrote: >> Hi Susan, >> >> what do you mean with "full-text" items, items which got content at all >> and are not mere "metadata" items or item which got content of a special >> mime type (pdf, doc, etc.)? >> >> Claudia >> >> >> >>> Any thoughts on how we would query the database to determine the >>> number of full-text items in our repository? These would be items >>> with the additional .txt file created after running media filter. >>> >>> Thanks, >>> Susan >>> -- >>> Susan Wells Parham >>> Head, Digital Library Development >>> Georgia Institute of Technology >>> Library & Information Center >>> 404-894-4522 >>> [EMAIL PROTECTED] >>> >>> ------------------------------------------------------------------------- >>> This SF.Net email is sponsored by the Moblin Your Move Developer's >>> challenge >>> Build the coolest Linux based applications with Moblin SDK & win great >>> prizes >>> Grand prize is a trip for two to an Open Source event anywhere in the >>> world >>> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >>> _______________________________________________ >>> DSpace-tech mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/dspace-tech >>> >> >> ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
