https://connect.hyland.com/t5/nuxeo-forum/querying-null-empty-values-in-complex-properties/m-p/314943#M1944 <P>With such a schema</P> <PRE><CODE>&lt;ubx_convention:avis&gt; &lt;item&gt; &lt;instance&gt;Instance Centrales/Conseil d'administration&lt;/instance&gt; &lt;date&gt;2014-10-09T22:00:00.00Z&lt;/date&gt; &lt;/item&gt; &lt;item&gt; &lt;instance&gt;Instance opérat/Conseil d'UF xxx&lt;/instance&gt; &lt;date/&gt; &lt;/item&gt; &lt;/ubx_convention:avis&gt; </CODE></PRE> <P>How can I build a query that returns documents that do not hold at least a void / empty / null date ?</P> Sat, 18 Oct 2014 15:44:13 GMT pibou_Bouvret 2014-10-18T15:44:13Z https://connect.hyland.com/t5/nuxeo-forum/querying-null-empty-values-in-complex-properties/m-p/314943#M1944 <P>With such a schema</P> <PRE><CODE>&lt;ubx_convention:avis&gt; &lt;item&gt; &lt;instance&gt;Instance Centrales/Conseil d'administration&lt;/instance&gt; &lt;date&gt;2014-10-09T22:00:00.00Z&lt;/date&gt; &lt;/item&gt; &lt;item&gt; &lt;instance&gt;Instance opérat/Conseil d'UF xxx&lt;/instance&gt; &lt;date/&gt; &lt;/item&gt; &lt;/ubx_convention:avis&gt; </CODE></PRE> <P>How can I build a query that returns documents that do not hold at least a void / empty / null date ?</P> Sat, 18 Oct 2014 15:44:13 GMT https://connect.hyland.com/t5/nuxeo-forum/querying-null-empty-values-in-complex-properties/m-p/314943#M1944 pibou_Bouvret 2014-10-18T15:44:13Z https://connect.hyland.com/t5/nuxeo-forum/querying-null-empty-values-in-complex-properties/m-p/314944#M1945 <P>If the only SQL equivalent involves <CODE>NOT EXISTS</CODE> then I don't think this can be done in a single query in Nuxeo.</P> Mon, 20 Oct 2014 13:51:42 GMT https://connect.hyland.com/t5/nuxeo-forum/querying-null-empty-values-in-complex-properties/m-p/314944#M1945 Florent_Guillau 2014-10-20T13:51:42Z