topic Re: Search querys problems [SOLVED] in Alfresco Archive

Search querys problems [SOLVED]

rhakaro — Mon, 09 Nov 2009 09:52:14 GMT

Hi all again!I have a new problem developing a query search in my Java code. I´m seeking some contents in alfresco, but it returns to me empty, only with the "Path" property fill. I´m doing this: …………. …………. Query query = new Query(Constants.QUERY_LANG_LU

Re: Search querys problems [SOLVED]

maqsood — Tue, 10 Nov 2009 08:42:10 GMT

try this @cm\\:name:\"plantilla*\" or @\\{http\\://www.alfresco.org/model/content/1.0\\}name:\'plantilla*\"

Re: Search querys problems [SOLVED]

rhakaro — Tue, 10 Nov 2009 10:57:27 GMT

Hi maqsood,

It still not running ;(
I see exactly the same results. Doing debug, I can check that only the only "if" that becomes "true" is the next:


if (namedValue.getName().endsWith("path") == true){
…..
‍‍‍‍

The rest of them are false all times. If I inspect the object "NamedValue" during the execution, it only has fill the "path" property:

{http://www.alfresco.org/model/content/1.0}path

Explained otherwise (sorry for my english if it is too bad ), my "rows" only have one property (path).

Thanks for answering, I´m working on it, if I find the solution I will post here. Maybe is a strange problem…

Re: Search querys problems [SOLVED]

tim-erwin — Tue, 10 Nov 2009 16:03:15 GMT

Hi,

same problem here. We are successfully getting all kinds of stuff out of Alfresco on Linux. However, since 3.2 lucene queries don't return any data besides the path any more. Switched on debug logging for webservice and it confirms (in Utils) that only the path property is created. Interestingly, on another System (Windows) it works as expected. Could this be an OS issue?

Regards
Tim

Re: Search querys problems [SOLVED]

rhakaro — Wed, 11 Nov 2009 09:18:24 GMT

I´m using Windows as SO, but I think this is not the problem….

Re: Search querys problems [SOLVED]

jonthomas500 — Mon, 16 Nov 2009 12:21:56 GMT

We are also experiencing this problem. We're running the alfresco- 3.2 on Solaris and using the webservice api.
Using the sample code from the developer website - the query result that's returned has a result set that contains only the path property named value.
Has anyone made any progress with this.
It is a bit of a show stopper to any further development.

Thanks

Jon

Re: Search querys problems [SOLVED]

tim-erwin — Tue, 17 Nov 2009 08:33:02 GMT

Sorry for the confusion of concerning the OS: the one that works (on Windows) simply is another version: Preview_2

That could be a temporary solution for some: use 3.2_Preview2 instead of 3.2r

I filed a bug for this, please have a look at it and support it so it gets fixed soon: https://issues.alfresco.com/jira/browse/ALFCOM-3660

Cheers,
Tim

Re: Search querys problems [SOLVED]

maqsood — Wed, 18 Nov 2009 10:17:57 GMT

try this:

Store STORE = new Store(Constants.WORKSPACE_STORE, "SpacesStore");
String ROOT = "/app:company_home/cm:"+ISO9075.encode("Folder Name");
String path = "PATH:\"/" + ROOT + "//.\" AND TYPE:\"{http://www.alfresco.org/model/content/1.0}content\""; 
final List<String> result = new ArrayList<String>();
final Query query = new Query(Constants.QUERY_LANG_LUCENE, path);
Node [] nodes = null;
try {      
nodes = WebServiceFactory.getRepositoryService().get(new Predicate(null,STORE,query));      
} catch (RepositoryFault e) {
e.printStackTrace();
} catch (RemoteException e) {
e.printStackTrace();
}
if (null != nodes){
NamedValue[] props = null;
for (final Node node : nodes) {
   props = node.getProperties();
   for(NamedValue prop : props) {
      if(prop.getName().endsWith(Constants.PROP_NAME) == true) {                   
         result.add(prop.getValue());
   }
}
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

hope it may resolve your problem

Re: Search querys problems [SOLVED]

rhakaro — Wed, 18 Nov 2009 12:39:46 GMT

Thank you very much maqsood!!!!!!!!!!!

It runs!!! It runs!!! hehe

I don´t know where is the problem with my code, maybe adding "ISO9075.encode" or "TYPE:\"{http://www.alfresco.org/model/content/1.0}content\" it´s all done. I don´t understand where is the problem, but now it is running and returning me all the properties I need.

I thik it´s posible that the problem was in acces to data in this way:


                    String nodeId = row.getNode().getId();
                    ContentResult contentResult = new ContentResult(nodeId);
                    
                    for (NamedValue namedValue : row.getColumns()){
                        if (namedValue.getName().endsWith(Constants.PROP_CREATED) == true){
                                     ………
                        }
                        ……………
                        ……………
                    }
‍‍‍‍‍‍‍‍‍‍‍‍

instead of:


                        NamedValue[] props = null;
         for (final Node node : nodes) {
            props = node.getProperties();
            int i = 0;
            for(NamedValue prop : props) {
               if(prop.getName().endsWith(Constants.PROP_NAME) == true) {                   
                  ………..
               }
               ………………
               ………………
            }
‍‍‍‍‍‍‍‍‍‍‍‍‍

Again, thank you a lot!

Re: Search querys problems [SOLVED]

tim-erwin — Wed, 18 Nov 2009 15:12:41 GMT

The big difference seems to be the web service method: you used query - the same I used, because it seemed to be the one for such kind of queries (http://wiki.alfresco.com/wiki/Repository_Web_Service#query) and it worked. maqsood suggests using get which I usually use for stuff I explicitly want to retrieve via uuid and so on.

What's the difference between get and query? Which one to use when?

Regards,
Tim

Re: Search querys problems [SOLVED]

rhakaro — Wed, 18 Nov 2009 15:24:32 GMT

That´s true, I did`t realize about that detail. I don´t know where is the diference, but I will work on to resolve it!

Re: Search querys problems [SOLVED]

maqsood — Thu, 19 Nov 2009 11:10:18 GMT

Even i don't know, I just try in the other way round and it works. me also working around it to find out which one to use and when.

Re: Search querys problems [SOLVED]

dcastro2716 — Fri, 18 Dec 2009 23:55:27 GMT

Somebody know if this is going to be like this from now on?? or is something with 3.2r2? because some books say that query is the rigth way to go, but it doesnt work to get all the properties anymore. We should use only get in the future?
thx.

dA.

Re: Search querys problems [SOLVED]

openpj — Thu, 04 Feb 2010 10:31:20 GMT

In Alfresco 3.2 Enterprise if you try to get results from the query method of the Repository Service, Alfresco will return only nodes with the following fields: uuid, types and aspects.
The columns field contains only the path of the node, but it should contain all the properties (as the previous versions of Alfresco).

The queryParents and queryChildren methods correctly return all the properties as expected.
It could be a bug or is this a wanted feature of Alfresco 3.2?

Re: Search querys problems [SOLVED]

relax — Thu, 11 Feb 2010 16:40:15 GMT

Hello,
I also have a problem for a search query problem. I want to search a group for some operation as rename display name.

public static void renameGroup2(String groupName, String newName) {
         String query = "+PATH:\"/sys:system/sys:authorities//*\" + @usr\\:authorityName:\""
               + groupName + "\""; 
         RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory
               .getRepositoryService();
         try {
            Node[] nodes = repositoryService.get(new Predicate(null, new Store(
                  "user", "alfrescoUserStore"), new Query(
                  Constants.QUERY_LANG_LUCENE, query)));
// but nodes is null!!!
            CMLUpdate update = new CMLUpdate(new NamedValue[] {Utils.createNamedValue("{http://www.alfresco.org/model/user/1.0}authorityName", newName)},
                  new Predicate(new Reference[] { nodes[0].getReference() },
                        null, null), null);‍‍‍‍‍‍‍‍‍‍‍‍‍

but nodes is null.
I tested query with:
+PATH:"/sys:system/sys:authorities//*" + @usr\:authorityName:"GROUP_test"
or
+PATH:"/sys:system/sys:authorities//*" + @usr\:authorityName:"test"

where rootgroup name is test.

I suppose have a problem in query. In Alfresco Node Browser
http://localhost:8080/alfresco/faces/jsp/admin/node-browser.jsp
I select

user://alfrescoUserStore

for

lucene search

what's the search text to search a rootgroup with name test?

Thank you

Re: Search querys problems [SOLVED]

relax — Fri, 12 Feb 2010 10:47:19 GMT

Hello,
this is XPath for a Group named test

/{http://www.alfresco.org/model/system/1.0}system/{http://www.alfresco.org/model/system/1.0}authorities/{http://www.alfresco.org/model/content/1.0}GROUP_test

present in store
workspace://SpacesStore

Re: Search querys problems [SOLVED]

maschlosser — Mon, 22 Feb 2010 19:31:04 GMT

Hi Folks,

I'm a little confuse here. After all what is the wright to go? get or query?

tks
MS