Search count(*)

okto — Mon, 22 Oct 2007 14:15:26 GMT

hi!!!I'm currently working with the Alfresco Webservices and I'd found an (really) annoying thing… I can't found via Lucene syntax a way to know how much results are returned by the query [like in the SQL query count (*) from TABLE].My query always returns 1000 results (in the repository.properties

Re: Search count(*)

rivetlogic — Fri, 26 Oct 2007 12:48:04 GMT

Hi,

You should be able to override any property using custom-repository.properties.

http://wiki.alfresco.com/wiki/Repository_Configuration

Also when you query using webservices you should be able to get the count from the resultset.

QueryResult result=repoService.query(STORE,new Query(Constants.QUERY_LANG_LUCENE, "PATH:\"/app:company_home/*\""),true);

ResultSet rs=result.getResultSet();

long count=rs.getTotalRowCount();

Query doesn't return the actual contents from the repository.

To read the content you need to use the contentService.

Best Regards,
Shagul Khaja

topic Search count(*) in Alfresco Archive

Search count(*)

Re: Search count(*)