Unable to compare two double columns within the same collection in Mongodb

[kamilkrzywanski]

Ported from: querydsl/querydsl#3916

Observed vs. expected behavior

I have a Collection in Mongodb with 2 fields, 'totalStock' and 'minStock',
I want to get all data where totalStock <= minStock by

QProduct product = QProduct.product;
BooleanBuilder booleanBuilder = new BooleanBuilder();
booleanBuilder.and(product.totalStock.loe(product.minStock));
productMongoRepository.findAll(booleanBuilder, pageable)

But the results returned empty, which should have expected data when checking through my Mongodb data explorer.

Below is the productMongoRepository class that extends MongoRepository and QueryDSLPredicateExecutor:

public interface ProductMongoRepository extends MongoRepository<Product,String>, QuerydslPredicateExecutor {
}

Both values of the POJO are in 'double' values:

public class Product {
...
    private double totalStock;
    private double reservedStock;
    private double minStock;
}

Environment
localhost, mongodb
Querydsl version: 5.1.0
Querydsl module: querydsl-apt, querydsl-mongodb
Database: MongoDB
JDK: 21

[github-actions]

This issue has been automatically closed because the author did not indicate they are willing to put in the effort needed to resolve it.

[kamilkrzywanski]

Refactored:
IN,NOT_IN,
BETWEEN,
EQ,
NE,
LT,
GT,
LOE,
GOE,
IS_NULL,
STARTS_WITH,
STARTS_WITH_IC,
ENDS_WITH,
ENDS_WITH_IC,
EQ_IGNORE_CASE,
STRING_CONTAINS,
STRING_CONTAINS_IC,
CONTAINS, CONTAINS_IC,
MATCHES,MATCHES_IC
OR is fine,

[LeeBoonKong]

Thanks a lot for addressing my issue 🙏🙏🙏🙏