Index and query multiple fields for nested object

[Tobbe]

Hello!

I have a document collection named Contact which contains an list of goals and the goal object looks like this:

    public class Goal
    {
        public string Name { get; set; }
        public double UnixDateTime { get; set; }
    }

Right now I'm using "Dynamic fields" to index this and it works when querying on a single property like this:

Index:

GoalsUnixTimes = contact.Goals.Select(g => CreateField("GoalsUnixTimes", g.UnixDateTime))

Query:

GoalsUnixTimes: 1517396156.0

Using the example above I get the expected result. But when trying to index and query on multiple properties I can't get it working. Check out example.png to see how it's indexed in RavenDb. The following is what I ended up trying with, without getting back any result at all.

Index:

Goals = contact.Goals.Select(g => CreateField("Goals", new { g.Name, g.UnixDateTime}))

Query:

Goals.UnixDateTime: 1517396156.0

When I get this working I want  to query on UnixDateTime and Name at the same time.

Any suggestions what I'm doing wrong here?

Regards Tobbe

[Oren Eini (Ayende Rahien)]

You can use this to do what you want:

 

GoalsUnixTimes = contact.Goals.Select(g => g.UnixDateTime)

Hibernating Rhinos Ltd  

Oren Eini l CEO l Mobile: + 972-52-548-6969

Office: +972-4-622-7811 l Fax: +972-153-4-622-7811

 

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

[Tobbe]

Thanks for your answer.

We came up with the following solution.

Index:

__ = contact.Goals != null && Enumerable.Any(contact.Goals) ? contact.Goals.Select(p => CreateField("Goals_ + p.Name, (double)p.UnixDateTime, true, true)) : null

Query example:

string goalName = "Some goal";
query = query.WhereBetweenOrEqual("Goals_" + goalName, dateSelection.StartDate, dateSelection.EndDate);

To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+u...@googlegroups.com.