topic Re: [SOLVED] repositoryService.query not returning metadata in Alfresco Archive

[SOLVED] repositoryService.query not returning metadata

mwildam — Wed, 17 Mar 2010 23:53:55 GMT

I searched for a document file (content node) and wanted to get back all the properties of the found node.But although usingQueryResult qresult = repositoryService.query(spacesStore, query, true);‍(last boolean parameter should mean that meta-information is included in the results) I only get the pa

Re: [SOLVED] repositoryService.query not returning metadata

rscottm — Mon, 29 Mar 2010 21:24:14 GMT

I've just had a similar problem. I was told, in a different forum post, that you can't get properties (at least not custom properties) back from Lucene search. What I was told to do (by Alfresco) is to get the node ids out of the result set, & do one-by-one lookups using the NodeService. I haven't been able to confirm that approach due to other problems.

Hope this helps,
scott

Re: [SOLVED] repositoryService.query not returning metadata

mwildam — Tue, 30 Mar 2010 08:38:46 GMT

What I was told to do (by Alfresco) is to get the node ids out of the result set, & do one-by-one lookups using the NodeService. I haven't been able to confirm that approach due to other problems.

I can confirm this - See http://forums.alfresco.com/en/viewtopic.php?p=83809#p83809

Re: [SOLVED] repositoryService.query not returning metadata

mwildam — Tue, 30 Mar 2010 08:41:55 GMT

But what I really wonder: Why are so many wrong samples cited. I found the sample that is not working at least 5 times and the correct one nowhere.

Re: [SOLVED] repositoryService.query not returning metadata

rscottm — Tue, 30 Mar 2010 22:40:31 GMT

Greetings!

I just stumbled on this in another forum. Don't use query, use get, as in this snippet:

      RepositoryServiceSoapBindingStub repository = WebServiceFactory.getRepositoryService();

      Query query = new Query(QUERY_LANG_LUCENE, config.getQueryString());

      Node[] nodes = repository.get(new Predicate(null, AlfrescoHelper.getDefaultStore(), query));

This approach works, nodes in the result array have all property values. Don't know what the performance impact might be, however.

No clue about wrong samples, but quality/quantity of documentation seems to be a general problem for Alfresco. ;-}

best,
scott

Re: [SOLVED] repositoryService.query not returning metadata

mwildam — Tue, 06 Apr 2010 22:19:31 GMT

Thanks, that works better. 🙂

Re: [SOLVED] repositoryService.query not returning metadata

mwildam — Tue, 06 Apr 2010 22:20:41 GMT

Before I was fetching ids and then retrieved node by node as a workaround - for sure your solution is more performant (as a SOAP web service can be performant).

Re: [SOLVED] repositoryService.query not returning metadata

unknown-user — Mon, 28 Jun 2010 19:00:02 GMT

Greetings!

I just stumbled on this in another forum. Don't use query, use get, as in this snippet:

      RepositoryServiceSoapBindingStub repository = WebServiceFactory.getRepositoryService();

      Query query = new Query(QUERY_LANG_LUCENE, config.getQueryString());

      Node[] nodes = repository.get(new Predicate(null, AlfrescoHelper.getDefaultStore(), query));

This approach works, nodes in the result array have all property values. Don't know what the performance impact might be, however.

No clue about wrong samples, but quality/quantity of documentation seems to be a general problem for Alfresco. ;-}

best,
scott

Where did you find this? Do you have a complete example?

Thank you

Re: [SOLVED] repositoryService.query not returning metadata

jcustovic — Thu, 03 Feb 2011 09:02:58 GMT

Could somebody explane why this code is working in every case:


Query query = new Query(QUERY_LANG_LUCENE, config.getQueryString());
Node[] nodes = repository.get(new Predicate(null, AlfrescoHelper.getDefaultStore(), query));
‍‍‍‍

And this code in numerous cases don't return all properties:

QueryResult qresult = repositoryService.query(spacesStore, query, true);‍