Databases
StackOverflow2013
Postsdbo
POOuerying an object inside ravendb document
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOuerying an object inside ravendb document
    primarykey
    data
    text
    <p>There is a doubt as of how to query or retrieve a value from an object stored in an document as follows in raven db.</p> <pre><code>class User { public String Id { get; set; } public AccountType AccountType { get; set; }Servicetax public String MainAccountMobileNo { get; set; } public UserStatus Status { get; set; } public String EmailId { get; set; } public String DisplayName { get; set; } public Object User { get; set; } } </code></pre> <p>Here i am storing three different types of classes into the object User. Say Customer,Retailer and Trader. </p> <pre><code>Customer { public String Name{ get; set; } public String Address { get; set; } public String MobileNo { get; set; } public String EmailId { get; set; } } </code></pre> <p>Retailer</p> <pre><code>{ public String Name{ get; set; } public String Address { get; set; } public String MobileNo { get; set; } public String EmailId { get; set; } } </code></pre> <p>Trader</p> <pre><code>{ public String Name{ get; set; } public String Address { get; set; } public String MobileNo { get; set; } public String EmailId { get; set; } } </code></pre> <p>Now is it possible to retrieve results based on the Customer's class detail? That is now i want to retrieve All the Customers based on Address in the customer class, So how will i do it? How to typecast the object user in the query to type customer. Thanks.<img src="https://i.stack.imgur.com/970ix.png" alt="Image of my document storage"></p> <p>The user object in the document can store any type of class's object like account info trader in the above image. So how can i query from the object type that cannot is not definite and changing.</p> <p><code>var Result = sess.Query&lt;UserAccountInfo&gt;().Where(x =&gt; x.AccountType == usertype &amp;&amp; ((AccountInfoCustomer)x.User).Customerstatus == CustomerStatus.Pending);</code> </p> <blockquote> <p>This is the query that's been tried and this is the exception that's been caught {"Url: \"/indexes/dynamic/UserAccountInfos?query=AccountType%253ADistributor%2520AND%2520User).Customerstatus%253APending&amp;start=0&amp;pageSize=128&amp;aggregation=None\"\r\n\r\nSystem.ArgumentException: The field ')_Customerstatus' is not indexed, cannot query on fields that are not indexed\r\n at Raven.Database.Indexing.Index.IndexQueryOperation.AssertQueryDoesNotContainFieldsThatAreNotIndexes()</p> </blockquote>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmarc_s
    1. USuser1811801
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POOuerying an object inside ravendb document
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POOuerying an object inside ravendb document
      1. USuser1811801
      1. VTFavorite
    3. VO
      singulars
      1. POOuerying an object inside ravendb document
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYes it is possible, but I don't see the Customer class referenced in your User Class.
      singulars
      1. POOuerying an object inside ravendb document
      1. USBrett Allred
    2. COAfter you fix your classes to show us how you are relating them, also show what query you have tried so we understand your intent.
      singulars
      1. POOuerying an object inside ravendb document
      1. USMatt Johnson
    3. COI am storing customer class in the object type that i have mentioned as user inside the user class
      singulars
      1. POOuerying an object inside ravendb document
      1. USuser1811801
 

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