What is the correct way to create a "having" condition that compares two fields? For example:

        HAVING available_to_promise_total <= minimum_stock ;

I can use:

havingCondition = EntityCondition.makeCondition('availableToPromiseTotal', EntityOperator.LESS_THAN_EQUAL_TO, EntityFieldValue.makeFieldValue('minimumStock'));

which works, but I get the following warning:

=-=-=-=-=-=-=-=-= Database type warning in EntityExpr =-=-=-=-=-=-=-=-=
In entity field [ProductFacilityLocationQuantityTest.availableToPromiseTotal] set the value passed in [org.ofbiz.entity.condition.EntityFieldValue] is not compatible with the Java type of the field [java.math.BigDecimal]


Is there a cleaner way to do this type of thing that I am overlooking?


-Joe

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to