« Tables populated by Node Relationships Module | Main | examples of provenance field in DSPACE »

pdf uploads to DSPACE last year

Number of pdf files uploaded since 2009-09-10:
UDC: 5754
AgEcon: 5844
Total: 11,598

sql used
select count(name)   from ItemsByDateAccessioned, item2bundle, bundle2bitstream, bitstream  where item2bundle.item_id = itemsbydateaccessioned.item_id and item2bundle.bundle_id = bundle2bitstream.bundle_id and bitstream.bitstream_id = bundle2bitstream.bitstream_id and bitstream.name ~ '^.*pdf$' and ItemsByDateAccessioned.date_accessioned > '2009-09-10'::DATE ; 

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)