Hi,In function Community.countItems(), we made dso.countItems () for each collection and each subcommunity within: if some items are linked to several collections and/or subcommunities, these items are counted several times and the number of items in the Community is overvalued. In our repository, many items are linked to 2 collections (+- 20%).
In function Community.countItems(), why not use a query like this (similar query used in function Collection.countItems()):
query =" SELECT count(*) FROM communities2item, item WHERE "
+ "communities2item.community_id = ? "
+ "AND communities2item.item_id = item.item_id "
+ "AND in_archive ='1' AND item.withdrawn='0'";
Should this problem be reported in JIRA ?
Thanks
Fabian Smagghe
Université de Liège
<<attachment: f_smagghe.vcf>>
------------------------------------------------------------------------------ Download new Adobe(R) Flash(R) Builder(TM) 4 The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly Flex(R) Builder(TM)) enable the development of rich applications that run across multiple browsers and platforms. Download your free trials today! http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
