Non join EF queries that return a single result but contain multiple field conditions return incorrect data

[hippiehunter]

$filter=CustomerNumber ne 0 and CustomerNumber lt 8

The provider attempts to optimize this to a keyed read because there is only one field and it has a key, but it doesn't handle the multiple conditions.

Aha! Link: https://synergex.aha.io/features/HC-16