I am applying the query to get records which are LessthanOREqual to 9, Price in MongoDB stored as string.

So whenever I appy filter like this:

filterDefinition&= Builders<DM.Content>.Filter.Lte(x => x.Price, "9");

It will return records less than 9 as well as some with greater than 9.

Can anyone suggest what's wrong?

CodePudding user response：

I don't think you should use $lte comparison operator to compare values in string datatype which is not accurate.

Instead, cast the price field to numeric datatype and then compare.

In MongoDB query command:

{ $expr: { $lte: [ { $toInt: "$price" }, 9 ] } }

Result