Selecting documents with empty strings in RavenDB Studio
This ought to be simple enough, but I can't get a select statement going in RavenDB Studio where I say "give me all documents where field NAME_x is empty". The usual suspects don't yield anything:
NAME_5:[[EMPTY_STRING]]
NOT NAME_5:[[EMPTY_STRING]] (just to see if the logic was backwards somehow)
NAME_5: [[NULL_VALUE]]
The index DOES include all fields (NAME_0 through NAME_5) and there ARE plenty of records that have this
(...)
"NAME_5": "",
(...)
so my quesion is - why don't they show up ? I guess the query's syntax is wrong, but I don't know where/how. Thanks for a hint !
Solution
This should just work.
See: http://live-test.ravendb.net/studio/index.html#databases/query/index/recentquery--187795092?&database=44438301
Here is what I get when I try.
- RavenDB specify Lucene vs Corax in C# code
- RavenDB index with child list
- Building a generic search for RavenDb - failing to create Expression<Func<T,object>>
- How to ignore a property during serialization for RavenDB
- Is it possible to create RavenDB map-reduce index that contains generic type via IndexCreation.CreateIndexes?
- How can I execute a JS index in RavenDB?
- Update RavenDB Raven-Clr-Type after moving class to new namespace
- Does RavenDB tokenize and filter queries?
- RavenDb: Why filtering while string == null filters too much?
- How can I get .Json dataset on a live ravendb server using fast-api?
- RavenDB 5.4 serializing and deserializing Decimal format
- RavenDB Python Client UseOptimisticConcurrency, does this option exist?
- Query RavenDB 5 with complex logic
- How to set unique-constraint index in RavenDB 5.4?
- RavenDB Embedded license not registering
- RavenDB LINQ query - matching index field to at least one value from a collection
- How to insert update a document in RavenDB Studio (RQL)
- Understanding open source blog engines RaccoonBlog & Subtext
- RavenDB v5.4: globally wait for indices to finish before reads for integration tests
- Store NoSQL data on SQL Server?
- Run RavenDB Embedded in Memory
- RavenDB Restore Stuck
- How to async join tables in RavenDB
- Generate test data in Raven DB
- RavenDB update denormalized reference and stale indexes
- How to query Ravendb document size
- RavenDB ETL to SQL, how to store entire document ('this') in jsonb column?
- List RavenDB collections, using py-ravendb
- How do I add the first and last value in a map reduce RavenDB index
- How do I join and project a multi-map index?