.sum() on TimeSpan result in InvalidQueryException

[Ivan Montilla]

I have this LINQ query:

In the line 10, record.Lasts is a TimeSpan, and the generated RQL query is:

There are some workaround to operate with TimeSpan in queries?

[Ivan Montilla]

Sorry, the code was removed.

LINQ query:

from book in _session.Query<ConsumptionBook>()

where book.ServiceId == serviceId

where book.Period == period

select new ConsumptionBookResumeOutputModel

{

Calls = new ConsumptionBookResumeOutputModel.CallResume

{

Amount = book.CallsAmount,

Calls = book.Calls.Count,

Lasts = new TimeSpan(book.Calls.Sum(record => record.Lasts.Ticks))

}

}

Generated RQL:

from 'Vadavo/Telecom/ConsumptionBook' as book

where (book.ServiceId = "1217-A") and (book.Period = "152")

select {

    Calls : {Amount:book.CallsAmount,Calls:book.Calls.length,

    Lasts:new System.TimeSpan(book.Calls.map((function(record){return record.Lasts.Ticks;})).reduce(function(a, b) { return a + b; }, 0))},

    Messages : {Amount:book.MessagesAmount,Messages:book.Messages.length},

    Data : {Amount:book.DataAmount,Kilobytes:book.Data.map(function(record){return record.Kilobytes;}).reduce(function(a, b) { return a + b; }, 0)}, SpecialServices : {Amount:book.SpecialAmount,Services:book.Special.length}

}

[Grisha Kotler]

Hi Ivan,

TimeSpan isn't supported yet in projections.

You can track the status of this issue here:

https://issues.hibernatingrhinos.com/issue/RavenDB-15903

In the meantime you can return the ticks in the projection:

public class ConsumptionBookResumeOutputModel
{
    public long Ticks { get; set; }

    public TimeSpan Lasts => new TimeSpan(Ticks);
}

Grisha Kotler Team Leader   /   Hibernating Rhinos LTD Mobile:  +972-54-5868647 Sales:  sa...@ravendb.net Skype:  grisha.kotler Support:  sup...@ravendb.net

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/ravendb/83c2c28f-b26f-49dd-b39e-304af364203cn%40googlegroups.com.

[Ivan Montilla]

Hi Grisha, I see that the issue is solved and merged. Thank you!