1 Reply Latest reply on Apr 10, 2013 4:00 AM by aklimets

    Query builder 'order by'

    krzysztof grams

      Hi all,

       

      I'm using query builder to retrieve result. Generated query statement is:

           /jcr:root/content/dam/myFolder//element(*, dam:Asset) order by jcr:content/metadata/general/@views descending

      The attribute 'views' is of xtype numberfield, but of course numberfield is a textfield with only numbers allowed inside and stored as String.

      Ordering by this attribute returns hits ordered in descending alphabetical order.

      My question is if it's possible to execute query with ordering by number value of it's attribute, not string value.

       

      Thanks a lot for help