How to negate "exists()"?

289 views
Skip to first unread message

Alexander Klaus

unread,
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. 
E.g. 
    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)

unread,
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 ravendb+u...@googlegroups.com.
To post to this group, send email to rav...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ravendb/c0b9d48b-4eb9-462d-872d-93de835af6b6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


--
Oren Eini
CEO   /   Hibernating Rhinos LTD
Skype:  ayenderahien
Support:  sup...@ravendb.net
Reply all
Reply to author
Forward
0 new messages