Mongodb c# Conditions in query LINQ

Question

My query look like this:

var query = from p in collection
where p.MinStockQuantity >= p.StockQuantity
select p;

I can't run because I have exception: Unsupported filter: ([MinStockQuantity] >= [StockQuantity])

This query also does not work, the same bug.

    var collection = database.GetCollection<Product>("Product");
    var builder = Builders<Product>.Filter;
    var filter = builder.Where(o => o.MinStockQuantity > o.StockQuantity);
    var query = collection.Find(filter).ToListAsync().Result;

How can I compare 2 fields ?

sifa vahora · Accepted Answer · 2017-09-28 05:25:08Z

1

I know I am quite late but this works perfectly,try this :

  var collection = database.GetCollection<Product>("Product");
        var builder = Builders<Product>.Filter;
        var filter = builder.Gt(o => o.MinStockQuantity , o.StockQuantity);
        var query = collection.Find(filter).ToListAsync().Result;

Gt here is greater than. there are various other methods like Gte =greater than equal to etc .

answered Sep 28, 2017 at 5:25

sifa vahora

11711 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kamil Budziewski · Accepted Answer · 2015-11-19 06:11:53Z

0

So my previous answer was obviously wrong. You shoud use that query

db.products.find({ $where: "this.MinStockQuantity > this.StockQuantity" })

To run this query in c# world you need to use BSON documents:

var doc = MongoDB.Bson.Serialization.BsonSerializer
         .Deserialize<BsonDocument>
         ("{$where: \"this.MinStockQuantity > this.StockQuantity\"}");
var result = collection.Find(new CommandDocument(doc));

I used that query in my test application and it yells proper results.

edited Nov 19, 2015 at 6:11

answered Nov 18, 2015 at 13:19

Kamil Budziewski

23.1k14 gold badges88 silver badges107 bronze badges

9 Comments

GrandNode Over a year ago

Thanks, but I have the same bug. MongoDB does not allow for comparison between two columns from each other?

Kamil Budziewski Over a year ago

@user5472920 what are the types of columns? Mongo allows you to compare columns from same object

Kamil Budziewski Over a year ago

@user5472920 could you post here whole exception with stacktrace? Maybe there is something in inner exception

GrandNode Over a year ago

I have bad news, MongoDB don;t support this queries :( groups.google.com/forum/#!topic/mongodb-user/bWmQ02jGi5A These queries are not supported because LINQ and FilterDefinitionBuilder queries need to be translated into the underlying MongoDB query language, and MongoDB queries don't support comparing two fields in a document to each other.

Kamil Budziewski Over a year ago

@user5472920 I have even worse news, it works just fine :) Check my edited answer

|

Collectives™ on Stack Overflow

Mongodb c# Conditions in query LINQ

2 Answers 2

Comments

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related