How to set clause between two fields in RavenDb?

66 Views Asked by At

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?

0

There are 0 best solutions below