How to compare two fields of same document in parse server?

Parse Server 📡
#1

I have a collection T , with 2 fields: Grade1 and Grade2 , and I want to select those with condition Grade1 > Grade2 , how can I get a query (parse server) like in MySQL? thanks

Select * from T Where Grade1 > Grade2
#2

new Parse.Query(“Ex”).greaterThan(key, value)
You can use chain call
.greaterThan(…).lessThan(…)

if you want to 2 field compare.
i think you should use
Query().map( callback, options)

#3

This is not possible with the common Parse Query operators. Instead you would use the MongoDB aggregation pipeline via Parse.Query.aggregate(…) and use the $expr operator like so:

{
    $expr: {
        $gt: ["$grade1", "$grade2"]
    }
}