topic Find documents whose title contains specific String in Alfresco Archive

Find documents whose title contains specific String

huijzer — Fri, 16 Feb 2007 12:04:21 GMT

Hi,I am writing a Freemarker template that will show all documents whose title contains a specific string, for instance 'xyz'. I tried several things, but have not had any succes. My current code is:<table cellpadding="3"> <tr> <th align="left">Name</th> <

Re: Find documents whose title contains specific String

kevinr — Fri, 16 Feb 2007 14:08:29 GMT

The XPath syntax for searching attributes is not correct, but anyway I suggest you use a Lucene search to find the documents you want - otherwise the XPath engine will have to walk ALL nodes in the repo one by one to match them! That would not be good for performance! You can use lucene searches which are much faster as they use the index files, like this:


companyhome.childrenByLuceneSearch["TEXT:alfresco"]
‍‍‍

will find all documents with the text 'alfresco' in them. Since you want to search on the title attribute, you want something like this:


companyhome.childrenByLuceneSearch["@cm\\:title:xyz"]
‍‍‍

See here for info on Lucene search syntax:
http://wiki.alfresco.com/wiki/Search#Finding_nodes_by_text_property_values

Note the extra escaping required to escape the '\' character for FreeMarker.

Hope this helps,

Kevin

Re: Find documents whose title contains specific String

huijzer — Fri, 16 Feb 2007 18:18:56 GMT

Thanks, that worked!!

I just ran into another small problem. If my search string is not 'xyz' but a string containing an underscore, the wildcard functionality does not work correctly.

So the following does not seem to work:


companyhome.childrenByLuceneSearch["@cm\\:title:*test_report*"] 
‍‍‍

Thanks for your help!

Arjan Huijzer

Re: Find documents whose title contains specific String

kevinr — Fri, 16 Feb 2007 18:34:20 GMT

Good to hear that worked. The underscore character will have been tokenized out by the Lucene parser - and converted into two words 'test' and 'report' - so you need to do the following phrase style search using quotes:


companyhome.childrenByLuceneSearch["@cm\\:title:\"test_report\""] 
‍‍‍

Note that you cannot currently use wildcards in combination with phrase searches - that will be added in a later version.

Thanks,

Kevin

Re: Find documents whose title contains specific String

huijzer — Sat, 17 Feb 2007 14:13:56 GMT

Kevin,

Thanks for your explanation. It's all clear to me now.
Looking forward to those wildcards with search phrases

Arjan