Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Contains is indeed not yet supported (Perhaps it should be, but that's another matter entirely - we only really add support for various operators when its asked for)</p> <p>As for multiple queries against Any, I assume you're trying to do dynamic data and you want to achieve something like</p> <pre><code>"X OR Y OR Z" </code></pre> <p>That's a tricky one, and the LINQ provider by default will aggregate those multiple WHERE clauses with AND, so your example looks like</p> <pre><code>"X AND Y AND Z" </code></pre> <p>Which will obviously never be the case.</p> <p>Your best option for this one is to drop down to the Lucene query (at least for now) and do something like this:</p> <pre><code>var results = s.Advanced.LuceneQuery&lt;Item&gt;() .Where(string.Format("Tags,:({0})", string.Join(" OR ", tags))); </code></pre> <p>Make sense?</p> <p>The query above will look something like</p> <pre><code>"Tags,:(X OR Y OR Z)" </code></pre> <p><em>Note: "Tags," informs RavenDB that Tags is an array</em></p> <p>Okay, [edit]!</p> <p>The easiest way to get what you actually <em>want</em> is to do something along these lines</p> <pre><code> new IndexDefinition&lt;Item, Item&gt;() { Map = docs =&gt; from doc in docs select new { Tags = doc.Tags }, Indexes = {{ x =&gt; x.Tags, FieldIndexing.Analyzed }} }.ToIndexDefinition(store.Conventions)); </code></pre> <p>Then to query for your ands, you can do something like this:</p> <pre><code> var results = s.Advanced.LuceneQuery&lt;Item, WhateverYouCalledThatIndex&gt;() .Where(string.Format("Tags:({0})", string.Join(" AND ", tags))); </code></pre> <p>Now, things to be aware of</p> <pre><code> Tags = doc.Tags </code></pre> <p>Will serialize that entire array into one giant blob, as it's just strings that will work for this example.</p> <p>I am looking at better ways of expressing this, it is unlikely that we'll come up with a LINQ-ish way of doing this, as it doesn't really map across very well - but it <em>is</em> an answer that will work :)</p> <p>I think I'd quite like to be able to at least do</p> <pre><code> Map = docs =&gt; from doc in docs select new { Tags = String.Join(" ", doc.Tags) }, </code></pre> <p>(This won't work so don't try it), but it is a bit more explicit about what you want to achieve.</p>
    singulars
    1. This table or related slice is empty.
    1. POLinq query with multiple Contains/Any for RavenDB
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSteve
    1. USRob Ashton
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POLinq query with multiple Contains/Any for RavenDB
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COClose, but no cigar! ;-) First of all, the version I use doesn't seem to work with the "Tags,:" syntax. However if I create a Tag class with a single property called Name (and use "Tags,Name:"), your solution works. But it doesn't do exactly what I need. I'd like it to return only those Items that have ALL of the tags in the tags list (not any one of the tags).
      singulars
      1. PO
      1. USCodingInsomnia
    2. COOkay, THAT is more difficult, how would you do that as a set based operation in a relational database? I think at this point you might actually have to create an index to merge those tags into a single field and specify the analyzer you you want, and use a Lucene query to say "All of these terms please"
      singulars
      1. PO
      1. USRob Ashton
    3. COYeah, it's not very pretty in a relational DB either, but the code I wrote in the question actually works with Entity Framework. Not pretty though, and hardly very efficient (which was part of the reason I figured that maybe Raven would be able to do a better job).
      singulars
      1. PO
      1. USCodingInsomnia
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload