topic Re: Search in a folder with Javascript in Alfresco Archive

Search in a folder with Javascript

patrickvanhoof — Thu, 22 Sep 2016 12:49:05 GMT

Hi,I want to search for a file by it's name in a given folder via Javascript. I use following code:nodes = search.luceneSearch("workspace://SpacesStore/61d28f13-24e0-434a-8b90-5ea54d2fafa2", "cm:name:" + nodeName);But I get following error:13:47:02,059 ERROR [org.springframework.extensions.webscript

Re: Search in a folder with Javascript

openpj — Thu, 22 Sep 2016 13:07:38 GMT

Try the following code:

nodes = search.luceneSearch("@cm\\:name:\"" + nodeName+ "\" AND PARENT:\"workspace://SpacesStore/61d28f13-24e0-434a-8b90-5ea54d2fafa2\"");

or you can get the node of the folder and then get all the children, using the database, for example in this way:

var folderNode = search.luceneSearch("TYPE:\"cm:folder\" AND @cm\\:name:\"<YOUR_FOLDER_NAME>\"")[0];

Another choise for finding the folderNode could be getting it using the discovery of the tree:

var folderNode = companyhome.childByNamePath("/YOUR/FOLDER/PATH");

Then you can get all the children:

var folderNodeChildrenXPathQuery = "*[@cm:name='"+messageFrom+"']";

var nodes = folderNode.childrenByXPath(folderNodeChildrenXPathQuery);

Hope this helps.

Re: Search in a folder with Javascript

afaust — Thu, 22 Sep 2016 16:52:15 GMT

I strongly recommend to avoid using search.luceneSearch() (and put it on a mental "ban list"). This operation uses a technical query language that has no support for the performance-related improvements around transactional metadata queries. Unfortunately it can't be easily removed from the public API since too many people rely on it and it is still being recommended (as in this thread) even though it should be obsolete.

(BTW: search.xpathSearch should also be avoided in favor of search.selectNodes - childrenByXPath on the other hand is perfectly fine)

The alternative to luceneSearch would be search.query:

var nodes = search.query({
   language: 'fts-alfresco', // this is the primary FTS language in Alfresco with best support (only other contender is cmis-alfresco)
   query : 'PARENT:"workspace://SpacesStore/61d28f13-24e0-434a-8b90-5ea54d2fafa2" AND =cm:name:"' + nodeName + '"'
});‍‍‍‍

Only "fts-alfresco" and "cmis-alfresco" are optimised to use the database for simple queries, like PARENT and exact name match conditions. search.selectNodes and childrenByXPath also use the database but in a less optimal way (conditions are evaluated in Java code and not during the database select).

Re: Search in a folder with Javascript

patrickvanhoof — Fri, 23 Sep 2016 14:03:30 GMT

Hi Axel,

I changed the query line to

query: 'PARENT:"workspace://SpacesStore/d54db46e-9539-45e9-8b49-55ed1ac1968a" AND "cm:name:" + nodeName'‍

because I think the syntax was not correct.

The script is running but I do not get results, although I know that in that parent there is a folder with that name.

Is this syntax ok for getting the search results:

for each (node in nodes.children) {

     log = "Folder " + node.name + " gevonden\n";
     logFile.content += log;
}
‍‍‍‍‍

Thanks,

Patrick

Re: Search in a folder with Javascript

afaust — Fri, 23 Sep 2016 14:10:09 GMT

The syntax was actually correct for finding exact matches and also supporting database queries. But your variant would also work, but you need to be aware of any whitespaces in nodeName which can break the query. That's why I put it in paranthesis.

The for-each loop should be fine to iterate, although I prefer the for-loop with an explicit iteration index.

Re: Search in a folder with Javascript

patrickvanhoof — Mon, 26 Sep 2016 09:04:04 GMT

Like this?

for (i = 0; i < nodes.length; i++) {
     log = "Folder " + nodes[i].name + " gevonden\n";
     logFile.content += log;
}
‍‍‍‍

Re: Search in a folder with Javascript

afaust — Mon, 26 Sep 2016 09:07:20 GMT

Yes, like this. The main issue with the for-each loop is that it is a deprecated extension

Re: Search in a folder with Javascript

patrickvanhoof — Mon, 26 Sep 2016 14:45:19 GMT

One last thing. I have following loop:

for (i = 0; i < nodes.length; i++) {

     log = "[" + nodeName + "]=\n" + "[" + nodes[i].name + "]?\n";
     logFile.content += log;
               
     if (nodes[i].name == nodeName) {

          log = "Folder " + nodes[i].name + " gevonden\n";
          logFile.content += log;

          found = true;
          break;
     }
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The first log gives me:

[Aerts_Dennis_94032021120_SAP4019]=

[Aerts_Dennis_94032021120_SAP4019]?

So they seem to be equal, but the following if statement results in false... Also when I use the === operator.

Re: Search in a folder with Javascript

afaust — Mon, 26 Sep 2016 14:50:03 GMT

The operator === can only be used for string objects if you are reasonably sure that both strings are native JavaScript strings. The scripting integration in Alfresco exposes strings from Java as well, which can by definition not be structurally identical with JavaScript strings.

The == should always work when comparing semantically identical strings. Why this does not yield true in your case I am not sure. Is there some kind of invisible control character in one of the strings?

Re: Search in a folder with Javascript

patrickvanhoof — Tue, 27 Sep 2016 13:12:14 GMT

As far as I know there is no control character in one of the strings. I tried different things but I can't get the if statement to return true...

Re: Search in a folder with Javascript

afaust — Tue, 27 Sep 2016 13:14:38 GMT

One desperate last ditch workaround you can try is forcing those values to be regular native strings.

if(String(nodeName) === String(nodes[i].name))‍

Re: Search in a folder with Javascript

patrickvanhoof — Tue, 27 Sep 2016 13:20:40 GMT

Bingo! 🙂