AnsweredAssumed Answered

Single search field for fulltext and property search

Question asked by deko Employee on Mar 19, 2012
With the upcoming OpenWorkdesk 3.2.0.0 Final release it will be possible to search for hits in Alfresco documents´ content and in Alfresco documents´ metadata with one single search field.

:!: In CMIS owbootstrap.xml you just have to configure the following node to use the Alfresco SQL search processor instead of the standard CMIS search processor:

                
<!– Special CSQLCProcessor for extended Alfresco content search abilities, use together with Alfresco repository only –>
<CSQLCProcessorClass>com.wewebu.ow.server.ecmimpl.cmis.alfresco.search.OwCMISAlfrescoCSQLCProcessor</CSQLCProcessorClass>

With this configuration it is then possible to use the <cbr_all> operator in a search template in the <where> clause like in the following example:



<where>
  <cbr_all>
     <whereprop editproperty="editable" symname="cmis:document.cmis:name">
     </whereprop>
     <literal />
  </cbr_all>
  …
</where>


:shock: As results of this search all documents will be listed, where the value of the requested search field is contained in the document´s name or in a document´s content.

Outcomes