https://connect.hyland.com/t5/nuxeo-forum/is-it-possible-to-configure-nuxeo-5-5-to-write-queries-in-simple/m-p/320069#M7070 <P>It's not possible. But I don't understand what it would gain you anyway, what's wrong with the current NXQL? It gets translated into pretty optimal SQL internally. Also note that <CODE>dc:title</CODE> is not a "complex property".</P> Mon, 21 May 2012 14:35:51 GMT Florent_Guillau 2012-05-21T14:35:51Z https://connect.hyland.com/t5/nuxeo-forum/is-it-possible-to-configure-nuxeo-5-5-to-write-queries-in-simple/m-p/320068#M7069 <P>In Nuxeo the main way to do searches is through NXQL, the Nuxeo Query Language, a SQL-like query language.</P> <P>Is it possible to use plain SQL lanaguage instead of NXQL,so that i dont need to do Complex property references(i.e dc:title,dc:subjects etc) after the SELECT, in the WHERE clause, and in the ORDER BY clause.</P> <P>Please let me know if this possible</P> Fri, 18 May 2012 09:35:25 GMT https://connect.hyland.com/t5/nuxeo-forum/is-it-possible-to-configure-nuxeo-5-5-to-write-queries-in-simple/m-p/320068#M7069 catherine_ 2012-05-18T09:35:25Z https://connect.hyland.com/t5/nuxeo-forum/is-it-possible-to-configure-nuxeo-5-5-to-write-queries-in-simple/m-p/320069#M7070 <P>It's not possible. But I don't understand what it would gain you anyway, what's wrong with the current NXQL? It gets translated into pretty optimal SQL internally. Also note that <CODE>dc:title</CODE> is not a "complex property".</P> Mon, 21 May 2012 14:35:51 GMT https://connect.hyland.com/t5/nuxeo-forum/is-it-possible-to-configure-nuxeo-5-5-to-write-queries-in-simple/m-p/320069#M7070 Florent_Guillau 2012-05-21T14:35:51Z