AnsweredAssumed Answered

Incorrect and partial  total result by lucene query

Question asked by epaoletti on Feb 27, 2009
Latest reply on Dec 1, 2009 by dgenard
Hi,

We are running the following lucene query via action

query = "PATH:\"/app:company_home/cm:Test/cm:Document//*\" AND @\\{http\\://www.alfresco.org/model/content/1.0\\}content.mimetype:application/pdf";
So we would like to get the total number of pdf files under the "company_home/Test/Document" space.

We had the following issue:
– the first results of the query was not complete. we had not the correct total number
– so we run again the query until we get the correct total number of pdf files

So the query seems to return the correct total number only after we run it more than one time (times depend on number of PDF files in the space).
for example: if we have about 5.000 files
the first query shows total=1.500 files
the second one shows total=2.410 files
………
Until the last one shows=5.000 files
then the queries became stable and result is 5.000.

There is some configuration parameters for the Lucene query to avoid this problems ?
We would like to have the correct total number at the first query.

Thanks for your help

Outcomes