topic Optimized Script comparing metadata in Alfresco Archive

Optimized Script comparing metadata

dranakan — Mon, 08 Aug 2011 05:53:42 GMT

Hello,I have a script checking that documents have not same metadata. It's working fine but I would like to optimise it.My documents have metadata FirmNb and DocumentNb. For all same types, the script search if same FirmNb and DocumentNb exist.The code get all documents for each types and after comp

Re: Optimized Script comparing metadata

dranakan — Thu, 22 Sep 2011 12:13:03 GMT

In SQL we can do something like this :


select a, b, c, count(*)
from tablename
where…
group by a, b, c
having count(*) > 1
‍‍‍‍‍‍‍

Could I do the same with Lucene ?

Thank you