I have a problem putting together an ordered query in Java integrated with Alfresco. I’m using OpenCMIS to integrate with Alfresco and I would like to perform a query similar to this
String query = "SELECT * FROM personalizedType:personalizedType WHERE " + "personalizedType:propertyNumber like '" + number + "' AND " + "cmis:name LIKE '" + name + "' AND "+ "personalizedType:propertyString like '" + nome + "' " + "ORDER BY personalizedType:propertyString"; ItemIterable<QueryResult> results = session.query(query, false);