topic Re: [SOLVED] Empty or null description in Lucene query in Alfresco Archive

[SOLVED] Empty or null description in Lucene query

nenad982 — Mon, 05 May 2014 13:21:50 GMT

Hi all,I want to write Lucene query that will return all content which has empty or null cm:description property. Is it possible to do that?Thanks…

Re: [SOLVED] Empty or null description in Lucene query

kaynezhang — Mon, 05 May 2014 15:47:00 GMT

You can try to use queries like ISNULL:"{http://www.alfresco.org/model/content/1.0}name" or ISNULL:"cm:name"

Re: [SOLVED] Empty or null description in Lucene query

nenad982 — Mon, 05 May 2014 20:03:00 GMT

Thanks kaynezhang, this will work for me.

Re: [SOLVED] Empty or null description in Lucene query

nenad982 — Wed, 07 May 2014 12:47:20 GMT

Hi all,

one update it does not work for empty property values just for NULL property values. Is there any way to find empty properties?

Thanks

Re: [SOLVED] Empty or null description in Lucene query

kaynezhang — Wed, 07 May 2014 14:37:00 GMT

Lucene/Solr does not support searching for empty values,so if you want search some field with null value ,you can define a default value(for example "none") in your model.then you can search for the default value.

If you really want to search empty field ,you can try following code


 *:* AND -@cm\:name:
‍‍

It is not a good way ,it has low performance.

Re: [SOLVED] Empty or null description in Lucene query

chetan — Mon, 02 Feb 2015 07:02:04 GMT

Hi Kaynezhang,

Can we use above mentioned query (ISNULL:"{http://www.alfresco.org/model/content/1.0}name" or ISNULL:"cm:name") to write a query using 'org.apache.lucene.search.Query' class. It would be a great help if you can explain with a example code snippet.

Thanks,
Chetan