lucene query issue when more than 1000 records

[jawwad]

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 some client restrictions(we cannot update a file).

any one please suggest how to solve this issue ? (remember we have no access to change the repository.properties file).

Thanks in advance.

[mrogers]

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.

[weareunite]

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.

[mrogers]

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

[weareunite]

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 ???

[mrogers]

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.