topic Re: Search content in specific folder in Alfresco Archive

Search content in specific folder

billmce — Wed, 28 Apr 2010 12:57:26 GMT

I've read the Search page on the wiki, I've searched the forums, I've read lucene documentation, I've read XPATH documentation … but the solution to this problem escapes me.I have folders in Alfresco laid out as:Company Home|……………….|……………….|Client Name|……………………………..|……………………………..|Accounting………………………

Re: Search content in specific folder

openpj — Wed, 28 Apr 2010 13:15:39 GMT

You have to encode in ISO9075 each space name, in this way:


var query = "PATH:\"/app:company_home"
+"/cm:"+search.ISO9075Encode("Client Name")
+"/cm:"+search.ISO9075Encode("Human Resources")+"//*\" +TEXT:\"searchString\" ";
‍‍‍‍‍

You can find this reference here:
http://wiki.alfresco.com/wiki/3.2_JavaScript_API#Search_API

Hope this helps.

Re: Search content in specific folder

billmce — Wed, 28 Apr 2010 14:16:37 GMT

Thank you … I had danced all around that solution without hitting it.
I appreciate you taking the time to give such a thorough solution.

Re: Search content in specific folder

billmce — Wed, 28 Apr 2010 14:53:33 GMT

Having past a major hurdle, I've got a little bit of work to do.

I've found that the lucene search is searching within the 'Data Dictionary'. My web scripts are in
Company Home / Data Dictionary / Web Script Extensions / com / mycompany

During testing, I hard coded the search string. To my surprise, in the results returned from the search was my javascript file.

Why is it searching outside the specified path? … and how can I stop it from searching outside the specified path?

Thanks

Re: Search content in specific folder

mikeh — Wed, 28 Apr 2010 15:03:28 GMT

You've currently got PATH as an optional search term - add a "+" in front, as you have for TEXT.

Thanks,
Mike

Re: Search content in specific folder

billmce — Wed, 28 Apr 2010 15:53:39 GMT

If I add the + I get no results at all … I'm certain that there are multiple files matching 'searchString' in the folder
/ Company Home / Client Name / Human Resources


var query = "+PATH:\"/app:company_home"
+"/cm:"+search.ISO9075Encode("Client Name")
+"/cm:"+search.ISO9075Encode("Human Resources")+"//*\" +TEXT:\"searchString\" ";
‍‍‍‍‍

I'm using Community Edition 3.3.

Any help very much appreciated.

Re: Search content in specific folder

openpj — Thu, 29 Apr 2010 06:32:57 GMT

Probably it could be a wrong setting of mimetype: can you check if all the files in that space have a correct value for the mimetype property?
From the node browser you have to check the content property in the properties section.

Re: Search content in specific folder

billmce — Thu, 29 Apr 2010 13:44:40 GMT

This just isn't giving me the kind of results I need.
What I want to do is search only files the folder '/Company Home/Fall and Associates/Creditors/TT900/' for the string "in other baskets".

In the folder '/Company Home/Fall and Associates/Creditors/TT900/' are two files.
One is a copy of the other. They both contain the string "in other baskets" – they both should match this search. I've added no other files to the repository.

I should find both files – but I don't. In addition, despite the '+PATH:' I am getting the script itself returned as a result (it's under '…/Data Dictionary /Web Script Extensions/…')


var query = "+PATH:\"/app:company_home"+"/cm:"+search.ISO9075Encode("Fall And Associates") + "/cm:"+search.ISO9075Encode("Creditors")+"/cm:"+search.ISO9075Encode("TT900") +"//*\" +TEXT:\"in other baskets\" ";

var results = search.luceneSearch(query);
‍‍‍‍‍

This is the result

<items>
−
<item>
<name>Duplicate2 of Kiva.pdf</name>
<title>
               number 2
            </title>
<size> 94,176 </size>
<author>billmc</author>
</item>
−
<item>
<name>searchDocs.get.js</name>
<title>
            </title>
<size> 1,708 </size>
<author>admin</author>
</item>
</items>

The 'searchDocs.get.js' is the name of the script (based on the Packt Book by Shariff in company). It should NOT be returned.
Missing is the expected 'Duplicate1 of Kiva.pdf' which is identitical (a copy) of the file returned.

Questions:
1) Is this lucene search syntax correct for what I'm trying to do?
2) Why do I keep getting matches from outside the PATH setting? How can I stop that?
3) Why do both results get returned (along with Alfresco system files of various kinds) when I do the search from the webclient … but only one is returned in the webscript?
4) Is there another way, besides lucene to do this?

I should add that this is on Community Edition 3.3 which we're using to evaluate Alfresco's suitability in our company. Search is obviously a huge factor in our evaluation.

Thanks in advance.

Re: Search content in specific folder

billmce — Thu, 29 Apr 2010 14:51:11 GMT

Simplifying a bit.

This doesn't return all the files .. and it seems to drop files now and then as I change the contents of the folder.


var query = "+PATH:\"/app:company_home"+"/cm:"+search.ISO9075Encode("Fall And Associates") + "/cm:"+search.ISO9075Encode("Creditors")+"/cm:"+search.ISO9075Encode("TT900") +"//*\"";

var results = search.luceneSearch(query);
‍‍‍‍‍

I have 3 copies of the same file in this folder … it only returns two of them.
I think I've got something somewhere eating the first result?

What's going on?
What would be the simplest way for me to see the result as far as a ftl file goes?
TIA.

Re: Search content in specific folder

billmce — Thu, 29 Apr 2010 15:55:37 GMT

That's what it is … I've got some problem in my xml.ftl file that is eating a result.
My html.ftl file returns the correct output.

Thanks for the patience.