topic Re: lucene query issue when more than 1000 records in Alfresco Archive

lucene query issue when more than 1000 records

jawwad — Mon, 06 Jun 2011 06:22:56 GMT

Hi,Stuck in lucene query issue.Problem is : Lucene query returns the 1000 records but actually there are 1600 records.i found the solution on this post http://forums1.man.alfresco.com/en/viewtopic.php?f=4&t=22178 but problem is we are not able to update the repository.properties file due to som

Re: lucene query issue when more than 1000 records

mrogers — Mon, 06 Jun 2011 08:46:42 GMT

If you upgrade to Alfresco Enterprise then you may be able to configure via the JMX console.

Otherwise you are stuck. I'd attack that problem from your sys admin end, it's important top be able to configure alfresco.

Perhaps more details of your requirement may help, the more recent versions of Alfreco have a query limit on the API or there are alternative ways of querying when you don't want to do full text search.

Re: lucene query issue when more than 1000 records

weareunite — Tue, 07 Jun 2011 05:25:56 GMT

Hello thanks for your reply.

We are using Alfresco Enterprise version : 3.2.2.7

Scenario is : we want to count the all the files in the any folder of the repository.

For this we write the lucene query with specific path and type:content like that .

hope you understand the scenario

Kindly tell which version support the "query limit"

and what are the alternatives ways of the querying?

Thanks in advance.

Re: lucene query issue when more than 1000 records

mrogers — Tue, 07 Jun 2011 07:02:48 GMT

On 3.2 Use the Node service or FileFolderService. No need for lucence for that sort of query.

Re: lucene query issue when more than 1000 records

weareunite — Tue, 07 Jun 2011 09:06:31 GMT

FileFolderService Class does not help to find the files which are on the deeper levels , it able to fetches folders not files. or either make a custom script that first retrieves the all folders at any level then count the files inside these folders but i this is not appropriate.

Other is NodeService Class it also returns only the immediate all child associations , i think this is also not helpful in the case when you count deeper level files and folders.

am i right ???

Re: lucene query issue when more than 1000 records

mrogers — Tue, 07 Jun 2011 09:40:46 GMT

Sorry did not realise you needed a deep count.

I presume that you can't add Java code either if you are unable to configure alfresco, On 3.2 my first approach to tackle this would be a couple of policies storing the count as a property on the folder, however that approach will cause contention on the higher folders. Unfortunatly I can't think of a Java Script way to get the count except to "walk" the tree. Maybe someone else has a better idea :mrgreen:

It may be worth calling Alfresco support to see if they have suggestions.