Cmis query: ordering multivalue property

[pajumbo]

Hello,

It's possible use a multivalue custom property like:

<property name="sm:area">
   <type>d:text</type>
   <multiple>true</multiple>
   <index enabled="true">
       <tokenised>both</tokenised>
   </index>
</property>
‍‍‍‍‍‍‍‍‍

to use the property for order by in a query?

"SELECT  * FROM sm:prop order by  sm:area asc"
‍‍‍

thank you

[jpotts]

If you look at the CMIS specification, you'll see that ORDER BY only works with properties who have "orderable" set to true. And according to the <a href="http://docs.oasis-open.org/cmis/CMIS/v1.0/cmis-spec-v1.0.html">spec</a>:

<blockquote>This property MUST be FALSE for any property whose cardinality is “"multi”.".</blockquote>

So you cannot use order by with a multi-value property.