LuceneQuery<> and NULL and NOT NULL queries

[Johan Nordberg]

What's the best way of dong IsNull and IsNotNull queries with a LuceneQuery<>?

I'd like to list Posts where Media Is Not Null, but where Media.Video Is Null.

So, I need the Lucene-version of this:

session.Query<Post>()

    .Where(x => x.Media != null && x.Media.Video == null)

I think I need to use a LuceneQuery because I need to sort by using a string variable, not a lambda.

[Oren Eini (Ayende Rahien)]

Media.Video:[[NULL_VALUE]] 

Note that you don't need to check that media is not null to access the video

[Johan Nordberg]

Thanks!

But I actually want to make sure that Media is not null as a part of my filter. I just want the documents that has some a Media, but not Media.Video. It's a query like "give me all emails that has an attachment, but I don't want this special kind of attachment".

[Oren Eini (Ayende Rahien)]

Media.Video:[[NULL_VALUE]] AND  -Media:[[NULL_VALUE]]

[Johan Nordberg]

Almost too simple. :)

Thanks a lot!

[sandip...@gmail.com]

Hi Oren Eini,

  Can you please send live example of null check, because I am using QueryParser to create the lucene query. So how can I create the lucene query for this scenario? 

Please reply me...

[Oren Eini (Ayende Rahien)]

This is from a thread in 2012

Please create a new thread with full details

--
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.
For more options, visit https://groups.google.com/d/optout.

--

Oren Eini CEO   /   Hibernating Rhinos LTD Mobile:  +972-52-548-6969 Sales:  sa...@ravendb.net Skype:  ayenderahien Support:  sup...@ravendb.net