[SOLVED] Empty or null description in Lucene query

[nenad982]

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…

[kaynezhang]

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

[nenad982]

Thanks kaynezhang, this will work for me.

[chetan]

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

[nenad982]

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

[kaynezhang]

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.