AnsweredAssumed Answered

How do I find all the documents with multiple values in a property?

Question asked by xkahn on Nov 20, 2017
Latest reply on Nov 22, 2017 by andy1

I have a property which can have multiple values, but it typically only has one value. It is defined as:

 

        <property name="sc:productName">
          <title>Products</title>
          <type>d:text</type>
          <mandatory>false</mandatory>
          <multiple>true</multiple>
          <index enabled="true">
            <atomic>true</atomic>
            <stored>false</stored>
            <tokenised>both</tokenised>
          </index>
        </property>

I need to find all the documents that have more than one assigned product. Or:

num(sc:productName) > 1

How can I do this in a query?

Outcomes