How to negate "exists()"?

Skip to first unread message

Alexander Klaus

Jun 18, 2019, 11:50:57 PM6/18/19
to RavenDB - 2nd generation document database
The list of RQL keywords has operator exists(), which can be used under WHERE, though there are no documentation on it.
My understanding, that it allows filtering documents where a specified field exists. 
    from Records where exists(Amount)

But how to negate exists() in order to get documents where the field DOESN'T exist?

An intuitive modification of the RQL above doesn't compile:
  from Records where not exists(Amount)

Oren Eini (Ayende Rahien)

Jun 19, 2019, 5:47:06 AM6/19/19
to ravendb
  from Records where true and not exists(Amount)

You received this message because you are subscribed to the Google Groups "RavenDB - 2nd generation document database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To post to this group, send email to
To view this discussion on the web visit
For more options, visit

Oren Eini
CEO   /   Hibernating Rhinos LTD
Skype:  ayenderahien
Reply all
Reply to author
0 new messages