topic Re: Search for nodes that do not have a property in Alfresco Forum

Search for nodes that do not have a property

neilecker — Sun, 01 Oct 2017 01:11:38 GMT

I'd like to search for nodes that do not have a specific property from the Javascript Console using fts-alfresco. Is this possible? I've tried several variations such as ISNULL, ISUNSET.In the following example, I'm trying to find nodes that do not have the custom property gry:documentNumber. var

Re: Search for nodes that do not have a property

andy1 — Mon, 02 Oct 2017 08:52:53 GMT

The answer depends on exactly what you mean ..... Do you want to find...

Nodes that do not have the property at all?
Nodes that have a null value for the property?
Nodes that have an empty string value for the property?
Nodes that are unqueryable as they generate no full text search tokens?
Multi-valued properties where any one of the values is null?
Some combination of the above.

There are several fields in the index to support such queries and some groupings which you have tried ISNULL, ISUNSET etc. I suspect you are probably looking for .......

...... -EXISTS:"gry:documentNumber"

Via the public API you can also facet on the PROPERTIES field and get reports of which properties are set over the results of a query.

Andy

Re: Search for nodes that do not have a property

neilecker — Mon, 02 Oct 2017 14:30:32 GMT

Thanks Andy!

Your assumption was correct, the EXISTS is what I needed to find nodes that do not have a particular property. Whatever resource I was looking at may have been old and didn't seem to have that option but I do see it listed here: Search in fields | Alfresco Documentation

So my query to find nodes of a certain type that did not have the property "gry:documentNumber" became the following:

var searchObj = {
     query: 'PATH:"/app:company_home/st:sites/cm:test-area/cm:documentLibrary/cm:Test//*" AND TYPE:"gry:content" AND -EXISTS:"gry:documentNumber" AND -ASPECT:"rma:record"',
     language: 'fts-alfresco'
}

Neil

Re: Search for nodes that do not have a property

Telmo — Thu, 27 May 2021 17:31:07 GMT

So, this should be the correct way for searching for the different scenarios:

Nodes that do not have the property at all? -EXISTS:"gry:documentNumber"
Nodes that have a null value for the property? ISNULL:"gry:documentNumber"
Nodes that have an empty string value for the property? "gry:documentNumber":""

and if I want to combine all of them it should be

-EXISTS:"gry:documentNumber" OR ISNULL:"gry:documentNumber" OR "gry:documentNumber":""

Am I right?

Thanks.

Re: Search for nodes that do not have a property

EddieMay — Fri, 28 May 2021 13:42:39 GMT

Hi @Telmo

Generally it is better to start a new thread rather than add to one where there is already an accepted solution - you are more likely to get a response with a new thread.

HTH,

Re: Search for nodes that do not have a property

franciscoduarte — Fri, 29 Oct 2021 14:13:52 GMT

Hi,

Is there a way to this with filterQueries ?

Something like "filterQueries:" [{"query:" "gry:documentNumber:null"}]

Thanks