How to set clause between two fields in RavenDb?

Asked Oct 27 '20 at 14:56

Active Oct 27 '20 at 20:34

Viewed 60 times

I try to

var result = await _session.Query<NewScreenerDto>()
    .Where(p => p.PSAR > p.PrevPSAR, true)
    .ToListAsync();

but I get this error message.

"Could not understand expression: Convert(from NewScreenerDtos, IRavenQueryable`1).Where(p => (p.PSAR > p.PrevPSAR), True)"

Does it mean that RavenDB cannot translate this simple query?

edited Oct 27 '20 at 20:34

Danielle

asked Oct 27 '20 at 14:56

Ali Taheri

What is the usage of the **true** parameter as a second parameter to the Where clause? Did you mean `Where(p => p.PSAR > p.PrevPSAR)` – Danielle Oct 27 '20 at 15:45
@Danielle I don't know. That was require and i tested either true and false. That description was 'exact' and i didn't deep on that. – Ali Taheri Oct 27 '20 at 17:50
can you run the query w/o the 'true' ? just use `Where(p => p.PSAR > p.PrevPSAR)` ? – Danielle Oct 27 '20 at 19:26
@Danielle no. This is required – Ali Taheri Oct 27 '20 at 19:34

0 Answers0