topic Failed to execute Xpath with xpathSearch in Alfresco Archive

Failed to execute Xpath with xpathSearch

riogrande — Thu, 11 Jun 2009 10:17:47 GMT

Hi all, I have made a very simple script : var results = search.xpathSearch("//*[@af:status='In']");logger.log("\n## Document with the status set to 'In' : \n")for each (result in results){ logger.log("# : " + result.properties["cm:title"] + "\n");}‍‍‍‍‍‍‍‍‍But I have this error : 12:07:01,625 ERR

Re: Failed to execute Xpath with xpathSearch

mikeh — Thu, 11 Jun 2009 13:54:05 GMT

Hi

There are two xpath implementations in the Alfresco search service: an optimised one and one that uses Jaxen. Unfortunately the one you're calling is the optimized version, which doesn't support attribute queries. There's a comment on the wiki about it, but it's easy to miss.

Fortunately, in 3.2 we're added a parameterized query interface. See the query API here: http://wiki.alfresco.com/wiki/3.2_JavaScript_API#Search_API

Set the language to "jcr-xpath" and your query should work.

Thanks,
Mike

Re: Failed to execute Xpath with xpathSearch

mikeh — Thu, 11 Jun 2009 14:07:24 GMT

Just to add… you can test your jcr-xpath style queries in the Node Browser by choosing the "selectnodes" type in the search dropdown.

Thanks,
Mike

Re: Failed to execute Xpath with xpathSearch

riogrande — Thu, 11 Jun 2009 14:24:07 GMT

Yes very easy to miss it when I'm looking in the 3.0 API

Ok so if I have understood, I can only use this query in Alfresco 3.2?
I'm working on Alfresco 3.0.0 (Stable 1526) so I can't use something like that (It's what you suggest right?)

search.query({query: "//.[@af:status='In']", language: jcr-xpath});

So, I have to use Lucene instead of xpath to do that? Or is it possible to "translate" my query in Jaxen to use the xpathSearch function (if it is possible how?).

Re: Failed to execute Xpath with xpathSearch

mikeh — Thu, 11 Jun 2009 14:35:32 GMT

In 3.0, you'd have to either expose the selectNodes API by extending (or overriding, or directly editing) the org.alfresco.repo.jscript.Search class to make it available to JavaScript or - yes - use a Lucene query instead.

Thanks,
Mike

Re: Failed to execute Xpath with xpathSearch

riogrande — Thu, 11 Jun 2009 15:16:25 GMT

Ok but the problem with lucene is the following:
The query is : @af\:status:"In"

Works fine with all status that I define, but not 'In'. So I sad to my self "ok you have just to change the "search-minimum" tag in the web-client-config-custom to 2 instead 3". But I have still no result with 'In'. Is there something like an (I don't know how to say that in English) "word ignore list"? Or did I miss again something?

Re: Failed to execute Xpath with xpathSearch

mikeh — Thu, 11 Jun 2009 15:35:15 GMT

Yes, it won't work with any of the Lucene stop words, i.e. something like

"a", "an", "and", "are", "as", "at", "be", "but", "by",
"for", "if", "in", "into", "is", "it",
"no", "not", "of", "on", "or", "such",
"that", "the", "their", "then", "there", "these",
"they", "this", "to", "was", "will", "with"‍‍‍‍‍

Mike

Re: Failed to execute Xpath with xpathSearch

riogrande — Thu, 11 Jun 2009 16:22:33 GMT

Ok anyway not really important for my script because I'm looking for another status, but for the advanced search it will be a problem. The easiest way for me is probably to change 'in' by something like 'available'.

So I finally manage to make the thing work (I was working on it since this morning, what a waste of time !)

search.luceneSearch("workspace://SpacesStore", "@af\\:status:\"Externalized\"");‍

Very important the \\ !

Anyway thanks for your answers MikeH it helps me to not became mad :mrgreen:

Re: Failed to execute Xpath with xpathSearch

riogrande — Sun, 14 Jun 2009 20:01:11 GMT

An other question in relation but for an other application. Is something like this suppose to work ?

var result = search.luceneSearch("workspace://SpacesStore/50755bba-4ba1-4b9e-88e9-3a64985474e1", "TYPE:\"cm:folder\" AND @cm\\:name:\"Marketing\"");‍

When I try this it works fine I got a result:

var result = search.luceneSearch("workspace://SpacesStore", "TYPE:\"cm:folder\" AND @cm\\:name:\"Marketing\"");‍

My structure is very simple
[img]http://www.digitalmindstudio.ch/~magicrio/alfresco/folder_structure.png[/img]
So instead of searching on company home in would like to search on the Archive folder, but it doesn't work.

Re: Failed to execute Xpath with xpathSearch

mikeh — Wed, 17 Jun 2009 20:38:15 GMT

The first parameter in that form of the API is the store, not a nodeRef.

You need to add the PARENT search term to scope it to the Archive space. See http://wiki.alfresco.com/wiki/Search#Simple_Queries for details.

Thanks,
Mike

Re: Failed to execute Xpath with xpathSearch

riogrande — Thu, 18 Jun 2009 08:53:03 GMT

Ok I not immediately understand but I get it :

var result = search.luceneSearch("workspace://SpacesStore", "PARENT:\"workspace://SpacesStore/50755bba-4ba1-4b9e-88e9-3a64985474e1\" AND TYPE:\"cm:folder\" AND @cm\\:name:\"Marketing\"");‍

But it doesn’t work for the children folders as mentioned. I have just the result of the parent space. So for example if I have :

Archive

And I set de following query :

var result = search.luceneSearch("workspace://SpacesStore", "PARENT:\"workspace://SpacesStore/50755bba-4ba1-4b9e-88e9-3a64985474e1\" AND TYPE:\"cm:folder\" AND @cm\\:name:\"Department 1\"");‍

Result => none
So how to make it works ?

Re: Failed to execute Xpath with xpathSearch

mikeh — Thu, 18 Jun 2009 11:50:41 GMT

"Department 1"'s parent isn't the archive space, so it's not part of the resultset.

Sounds like you need a PATH query instead if you want descendants as well as child nodes.

Something like:

PATH:"/app:company_home/cm:Archive//*" +TYPE:"cm:folder"‍

Note the "//*" which will search deeper than the immediate children.

Thanks,
Mike

Re: Failed to execute Xpath with xpathSearch

riogrande — Thu, 18 Jun 2009 14:45:54 GMT

I tried it in the node browser, works fine thanks!