topic Re: Query syntax error with Share advanced search and list constraint in Alfresco Archive

Query syntax error with Share advanced search and list constraint

ludo2000 — Fri, 22 May 2015 08:39:26 GMT

Hello,I'm using Alfresco community edition 4.2.c.I created a custom content type with a LIST constraint:<type name="abcersonaleDocumentazioneVaria"> <title>Personale - Documentazione Varia</title> <parent>cm:content</parent> <properties> <property name=

Re: Query syntax error with Share advanced search and list constraint

douglascrp — Mon, 25 May 2015 13:42:52 GMT

Yes, it seems to be a bug.
If you already know how it's creating the query, I think you already know where to make changes.

I've done some advanced search fixes, but I'm unable to find where I posted them.

Re: Query syntax error with Share advanced search and list constraint

douglascrp — Mon, 25 May 2015 17:54:18 GMT

I've just found the post where we talked about that bug.
https://forums.alfresco.com/forum/developer-discussions/alfresco-share-development/advanced-search-custom-metadata-share-or

Re: Query syntax error with Share advanced search and list constraint

ludo2000 — Tue, 26 May 2015 09:33:28 GMT

Thank you very much for the link, the problem was similar.

I modified this file:
alfresco-4.2.c/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/slingshot/search/search.lib.js

To fix the problem I added this line:


first = false;
‍‍‍

after line number 882.

Old code was:


else if (isMultiValueProperty(propValue, modePropValue))
                  { 
                     formQuery += (first ? '(' : ' AND (');
                     formQuery += processMultiValue(propName, propValue, modePropValue, false);
                     formQuery += ')';
                  }
‍‍‍‍‍‍‍‍

New code is:

else if (isMultiValueProperty(propValue, modePropValue))
                  {
                     formQuery += (first ? '(' : ' AND (');
                     formQuery += processMultiValue(propName, propValue, modePropValue, false);
                     formQuery += ')';
                     first = false; // Added by Ludo
                  }
<code>
first = false;

Now the query is correct.

Re: Query syntax error with Share advanced search and list constraint

douglascrp — Mon, 08 Jun 2015 18:08:56 GMT

It seems it is another bug, right?

Having the variable and not changing its value seems to be a unfinished code.

Thank you for sharing your solution.