Query syntax error with Share advanced search and list constraint

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

ludo2000

Hello,
I'm using Alfresco community edition 4.2.c.

I created a custom content type with a LIST constraint:

<type name="abc:personaleDocumentazioneVaria">
&nbsp; <title>Personale - Documentazione Varia</title>
&nbsp; <parent>cm:content</parent>
&nbsp; <properties>
&nbsp;&nbsp;&nbsp; <property name="abc:personaleDVCodiceFiscale">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <title>Codice fiscale</title>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <type>d:text</type>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <mandatory>true</mandatory>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <constraints>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <constraint ref="abc:codicefiscale16_constraint" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </constraints>
&nbsp;&nbsp;&nbsp; </property>
&nbsp;&nbsp;&nbsp; …
&nbsp;&nbsp;&nbsp; <property name="abc:personaleDVMatricola">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <title>Matricola</title>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <type>d:text</type>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <mandatory>true</mandatory>
&nbsp;&nbsp;&nbsp; </property>
&nbsp;&nbsp;&nbsp; <property name="abc:personaleDVCognome">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <title>Cognome</title>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <type>d:text</type>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <mandatory>true</mandatory>
&nbsp;&nbsp;&nbsp; </property>
&nbsp;&nbsp;&nbsp; <property name="abc:personaleDVNome">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <title>Nome</title>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <type>d:text</type>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <mandatory>true</mandatory>
&nbsp;&nbsp;&nbsp; </property>
&nbsp;&nbsp;&nbsp; <property name="abc:personaleDVDataDocumento">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <title>Data documento</title>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <type>d:date</type>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <mandatory>true</mandatory>
&nbsp;&nbsp;&nbsp; </property>
&nbsp;&nbsp;&nbsp; <property name="abc:personaleDVTiopDocumento">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <title>Tipo documento</title>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <type>d:text</type>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <mandatory>true</mandatory>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <constraints>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <constraint type="LIST">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <parameter name="allowedValues">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <list>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>Contratti ed incarichi</value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>Disposizioni di servizio</value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>Documentazione assunzione</value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>Documentazione contabile</value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>Documentazione personale riservata</value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>Documentazione previdenziale</value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>Titoli e formazione</value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>Varie</value>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </list>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </parameter>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <parameter name="caseSensitive">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>true</value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </parameter>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </constraint>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </constraints>
&nbsp;&nbsp;&nbsp; </property>
&nbsp; </properties>
</type>&nbsp; 
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

then, I configured Share advanced search with a "selectmany" control on the property with the LIST constraint (share-config-custom.xml):

 <config evaluator="model-type" condition="abc:personaleDocumentazioneVaria">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <forms>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <form id="search">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <field-visibility>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <show id="abc:personaleDVCodiceFiscale" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <show id="abc:personaleDVMatricola" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <show id="abc:personaleDVCognome" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <show id="abc:personaleDVNome" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <show id="abc:personaleDVDataDocumento" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <show id="abc:personaleDVTiopDocumento" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </field-visibility>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <appearance>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <field id="abc:personaleDVDataDocumento">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <control template="/org/alfresco/components/form/controls/daterange.ftl" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </field>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <field id="abc:personaleDVTiopDocumento">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <control template="/org/alfresco/components/form/controls/selectmany.ftl" >
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <control-param name="size">8</control-param>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <control-param name="mode">OR</control-param>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </control>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </field>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </appearance>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </form>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </forms>
&nbsp;&nbsp; </config>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

When I search without selecting list elements but only by other properties (for example abcersonaleDVNome="Giuliano"), the query is correct, here an example of the query from the log:

((TYPE:"abc:personaleDocumentazioneVaria" AND (abc:personaleDVNome:"Giuliano")) AND -TYPE:"cm:thumbnail" AND -TYPE:"cm:failedThumbnail" AND -TYPE:"cm:rating") AND NOT ASPECT:"sys:hidden"
‍‍‍

When I search selecting only one element from the list (for example abcersonaleDVNome="Giuliano", abcersonaleDVTiopDocumento:"Varie"), the query is correct, here an example of the query from the log:

((TYPE:"abc:personaleDocumentazioneVaria" AND (abc:personaleDVTiopDocumento:"Varie" AND abc:personaleDVNome:"Giuliano")) AND -TYPE:"cm:thumbnail" AND -TYPE:"cm:failedThumbnail" AND -TYPE:"cm:rating") AND NOT ASPECT:"sys:hidden"
‍‍‍

But when I search selecting two or more items from the list (for example abcersonaleDVNome="Giuliano", abcersonaleDVTiopDocumento:"Varie", abcersonaleDVTiopDocumento:"Titoli e formazione"), there is a syntax error in the query and the result is wrong, here an example of the query from the log:

((TYPE:"abc:personaleDocumentazioneVaria" AND (((abc:personaleDVTiopDocumento:"Titoli e formazione") OR (abc:personaleDVTiopDocumento:"Varie"))abc:personaleDVNome:"Giuliano")) AND -TYPE:"cm:thumbnail" AND -TYPE:"cm:failedThumbnail" AND -TYPE:"cm:rating") AND NOT ASPECT:"sys:hidden"
‍‍‍

The correct query would be:

((TYPE:"abc:personaleDocumentazioneVaria" AND (((abc:personaleDVTiopDocumento:"Titoli e formazione") OR (abc:personaleDVTiopDocumento:"Varie")) AND abc:personaleDVNome:"Giuliano")) AND -TYPE:"cm:thumbnail" AND -TYPE:"cm:failedThumbnail" AND -TYPE:"cm:rating") AND NOT ASPECT:"sys:hidden"
‍‍‍

Is this a bug? Is there a workaround?

Thank you very much in advance.

douglascrp

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.