Lucene query on multiple values property?

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.

nenad982

Hi all,

I would like to create lucene query that will return me all the nodes of specific type that has specific value for some multivalued property. So for example:

Custom type:

<type name="xyz:cutsomType">
&nbsp;&nbsp;&nbsp; <title>Type title</title>
&nbsp;&nbsp;&nbsp; <parent>cm:content</parent>
&nbsp;&nbsp;&nbsp; <properties>
&nbsp;&nbsp;&nbsp;<property name="xyz:prop1">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<type>d:text</type>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<mandatory>false</mandatory>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<multiple>false</multiple>
&nbsp;&nbsp;&nbsp;</property>
&nbsp;&nbsp;&nbsp;<property name="xyz:prop2">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<type>d:text</type>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<mandatory>false</mandatory>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<multiple>false</multiple>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<constraints>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<constraint ref="xyz:constraint1" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</constraints>
&nbsp;&nbsp;&nbsp;</property>
&nbsp;&nbsp;&nbsp; </properties>
</type>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Constraint:

<constraint name="xyz:constraint1" type="LIST">
&nbsp;&nbsp;&nbsp; <parameter name="allowedValues">
&nbsp;&nbsp;&nbsp;<list>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value></value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>AB XYZ</value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>CD IJK</value>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <value>EF OPQ</value>
&nbsp;&nbsp;&nbsp;</list>
&nbsp;&nbsp;&nbsp; </parameter>
</constraint>
‍‍‍‍‍‍‍‍‍‍‍‍

So I would like to find all nodes of type 'xyz:cutsomType' which have 'CD IJK' as one of the values for 'xyzrop2' property?

I used fts-alfresco and I wrote this query:

TYPE: "xyz:cutsomType" AND xyz:prop2: "CD IJK"
‍‍‍

but this does not works as expected.

Does somebody know how to write this query?

Thanks a lot…

abarisone

Hi,
try the solution described here https://forums.alfresco.com/forum/developer-discussions/alfresco-api/fts-alfresco-search-multi-value-property-06102013-1900

Regards,
Andrea