topic Re: Help: Want AND search behavior in category search in advanced search in Alfresco Archive

Help: Want AND search behavior in category search in advanced search

yuva0103 — Tue, 24 Dec 2013 08:45:44 GMT

Hi, Added category in advance search form for content, but when selecting multiple categories, it works like OR behavior. I want to search like AND, Is there any configuration to do this.Please help, I'm new to alfresco. TIA

Re: Help: Want AND search behavior in category search in advanced search

afaust — Fri, 27 Dec 2013 16:00:02 GMT

Hello,

yes, there is configuration for it, which unfortunately was not documented until just now. See <a href="https://wiki.alfresco.com/wiki/Forms#category.ftl">the Forms wiki page</a> for details on the <b>mode</b> parameter.

Regards
Axel

Re: Help: Want AND search behavior in category search in advanced search

yuva0103 — Mon, 30 Dec 2013 08:39:44 GMT

Its not working Still working like default <b>OR</b> behavior.

here is the change I made in share-form-config.xml for category

<blockcode>
                <field id="cm:categories">
                  <control template="/org/alfresco/components/form/controls/category.ftl">
                    <control-param name="compactMode">true</control-param>
          <control-param name="mode">and</control-param>
          <control-param name="showSubCategoriesOption">true</control-param>
                  </control>
               </field>
</blockcode>

Please let me know if I missing anything.

Re: Help: Want AND search behavior in category search in advanced search

yuva0103 — Fri, 17 Jan 2014 08:39:54 GMT

I'm not sure this is best solution or not, I solved this requirement by a small change in search.lib.js file in path alfresco\WEB-INF\classes\alfresco\templates\webscripts\org\alfresco\slingshot\search.

In method getSearchResults(params) change this line. 'OR' to 'AND'

<blockcode>
catQuery += (firstCat ? '' : ' AND ') + "PATH:\"" + catNode.qnamePath + (useSubCats ? "//*\"" : "/member\"" );
</blockcode>

Re: Help: Want AND search behavior in category search in advanced search

ipirat — Sat, 03 May 2014 10:49:11 GMT

Hi,

having not much background in Alfresco, but a lot of background in search, here my suggestion:

<ul>
<li>if the user selects several categories within the same category, they should be connected with OR (e.g. user selects languages/English and languages/German => they most probably want documents taht are German or English, not documents which are English and German at the same time)
<li>if the user selects several categories contained in different categories, they should be connected with AND (e.g. user selects langages/English and region/EMEA => they most probably want documents in English language from EMEA, not all English documents from any region plus all documents from EMEA in any language)
</ul>

(assuming a 'properly built' category tree – where the subcategories are actually subcategories)