EXISTS (Field) - EXISTS (Field) - Alfresco - Alfresco Search Enterprise - Alfresco/Alfresco-Search-Enterprise/4.2/Alfresco-Search-Enterprise/Using/Field-queries/EXISTS-Field - 4.2 - 4.2

Alfresco Search Enterprise

Platform
Alfresco
Product
Alfresco Search Enterprise
Release
4.2
License
ft:lastPublication
2025-10-21T22:01:30.506000
ft:locale
en-US

The query intent can be summarized in “give me all nodes that have a value for the property/field I requested”. This is very similar to the previous one, the difference is that the NULLPROPERTIES field is not involved in this scenario.

The value of a clause whose field is EXISTS could be:

  • An unqualified name will be expanded to a fully qualified name using the default namespace.
  • a prefixed name is expanded, for example cm:name => {http://..}content}name).
  • a fully qualified name.
  • a field name, for example ID, OWNER, READER.

If the value is associated to a property definition then a boolean query is executed that has the following clause:

  • PROPERTIES (MUST) Otherwise, in case of a field (e.g. OWNER, ID, READER) a wildcard query is built using that field, for example OWNER:*.