How to search Alfresco for empty property?

iceja — Mon, 29 Jun 2020 16:14:17 GMT

I have Alfresco 5.2 and my task is "to get all documents with empty (one of) property", I am creating a query

searchParameters.setQuery("search +TYPE:\"ecmcndintregst:nd_int_reg_standards\" +@ecmcnddoc\\:doc_name_ru:\"\" -ASPECT:\"ecmcdict:inactive\" AND ( @ecmcnddoc\\:doc_kind_cp_ecmcdict_value:\"mek\")");

And I got all the documents thus: with either - empty and non-empty ecmcnddoc:doc_name_ru
how can I get ONLY empty ecmcnddoc:doc_name_ru ?

Thank you
please tell me what am I doing wrong? How to search solr for empty properties? When I submit +@ecmcnddoc\:doc_name_ru:"" (without slash) I got all documents with ANY ecmcnddoc:doc_name_ru value
Thank you

Re: How to search Alfresco for empty property?

cesarista — Tue, 07 Jul 2020 06:44:09 GMT

Hi:

Did you try with ISNULL operator ? Maybe it can do the job for your use case.

Anyway I link some general reference for custom alfresco-fts searches:

https://docs.alfresco.com/5.2/concepts/rm-searchsyntax-fields.html

Regards.

--C.

topic Re: How to search Alfresco for empty property? in Alfresco Forum

How to search Alfresco for empty property?

Re: How to search Alfresco for empty property?