Lucene query on multiple values property?

[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">
    <title>Type title</title>
    <parent>cm:content</parent>
    <properties>
   <property name="xyz:prop1">
      <type>d:text</type>
      <mandatory>false</mandatory>
      <multiple>false</multiple>
   </property>
   <property name="xyz:prop2">
      <type>d:text</type>
      <mandatory>false</mandatory>
      <multiple>false</multiple>
      <constraints>
         <constraint ref="xyz:constraint1" />
      </constraints>
   </property>
    </properties>
</type>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Constraint:

<constraint name="xyz:constraint1" type="LIST">
    <parameter name="allowedValues">
   <list>
       <value></value>
       <value>AB XYZ</value>
       <value>CD IJK</value>
       <value>EF OPQ</value>
   </list>
    </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...

Regards,
Andrea

[sanket]

These links will help you.

http://wiki.alfresco.com/wiki/Search

https://wiki.alfresco.com/wiki/Full_Text_Search_Query_Syntax

[nenad982]

Thank you for your answers, but those references I saw already and I didn't have enough luck/knowledge to create valid query.

So it would be helpful for me if you can give some query example based on sample type and constraint that I provided.

Thanks a lot…