topic Searching for nodes with out a property in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/searching-for-nodes-with-out-a-property/m-p/214012#M167142 <HTML><HEAD></HEAD><BODY><SPAN>I've been trying to return all nodes that don't have a specific property assigned. I've tried all of the combinations below with out the results that I'm after.</SPAN><BR /><BR /><SPAN>model.test = search.luceneSearch("+@custom\\:lifeCycle\\:");</SPAN><BR /><SPAN>model.test = search.luceneSearch("+@custom\\:lifeCycle:*");</SPAN><BR /><SPAN>model.test = search.luceneSearch("+ISNULL:\"custom:lifeCycle\"");</SPAN><BR /><SPAN>model.test = search.luceneSearch("+ISUNSET\\:\"custom:lifeCycle\"");</SPAN><BR /><SPAN>model.test = search.luceneSearch("ISNULL:\"custom:lifeCycle\"");</SPAN><BR /><SPAN>model.test = search.luceneSearch("ISNOTNULL:\"cm:lifeCycle\"");</SPAN><BR /><SPAN>model.test = search.luceneSearch("ISNOTNULL:\"custom:lifeCycle\"");</SPAN><BR /><SPAN>model.test = search.luceneSearch("ISNULL:\"\@{custom.model\}lifeCycle\"");</SPAN><BR /><SPAN>model.test = search.luceneSearch("ISNULL:\"custom:lifeCycle\"");</SPAN><BR /><SPAN>model.test = search.luceneSearch("(ISNOTNULL\\:\"custom\\:lifeCycle\")");</SPAN><BR /><SPAN>model.test = search.luceneSearch("(ISUNSET\\:\"custom\\:lifeCycle\")");</SPAN><BR /><BR /><SPAN>So to recap, what I want is to find all nodes that doesn't have node.properties['custom:lifeCycle'] value defined.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Ryan Thorburn.</SPAN></BODY></HTML> Sun, 25 Apr 2010 02:40:46 GMT zezom 2010-04-25T02:40:46Z Searching for nodes with out a property https://connect.hyland.com/t5/alfresco-archive/searching-for-nodes-with-out-a-property/m-p/214012#M167142 I've been trying to return all nodes that don't have a specific property assigned. I've tried all of the combinations below with out the results that I'm after.model.test = search.luceneSearch("+@custom\\:lifeCycle\\:");model.test = search.luceneSearch("+@custom\\:lifeCycle:*");model.test = search.l Sun, 25 Apr 2010 02:40:46 GMT https://connect.hyland.com/t5/alfresco-archive/searching-for-nodes-with-out-a-property/m-p/214012#M167142 zezom 2010-04-25T02:40:46Z Re: Searching for nodes with out a property https://connect.hyland.com/t5/alfresco-archive/searching-for-nodes-with-out-a-property/m-p/214013#M167143 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>ISNULL will check for no value</SPAN><BR /><SPAN>ISUNSET will check for no value and that the type/aspect is present</SPAN><BR /><BR /><SPAN>You should be able to use </SPAN><BR /><BR /><SPAN> </SPAN><PRE class="language-none line-numbers"><CODE>ISUNSET:"prefix:localname"<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN> </SPAN><PRE class="language-none line-numbers"><CODE>ISNULL:"{uri}localname"<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Both QName forms are supported for both methods.</SPAN><BR /><BR /><SPAN>Are you sure your model is loaded? If the property is unknown to the DD then it will not find it.</SPAN><BR /><BR /><SPAN>Are you trying to find a node that does not have an aspect defined? You would have to look for one of its mandatory properties.</SPAN></BODY></HTML> Mon, 26 Apr 2010 11:12:56 GMT https://connect.hyland.com/t5/alfresco-archive/searching-for-nodes-with-out-a-property/m-p/214013#M167143 andy 2010-04-26T11:12:56Z