posted 13 years ago
hi,
the indexStatusType is object in table has indexStatusTypeId of type long, and this attribute in database has the following values: 1,2,3, empty(null) i had write the previous code supposing to get notEqual(2) and notEqual(3), but i got only the equal (1) result.
i am also trying to write the following
Expression exp;
ExpressionBuilder builder = new ExpressionBuilder();
Expression expTwo;
ExpressionBuilder builderTwo = new ExpressionBuilder();
exp = builder.get("indexStatusType").isNull();
expTwo = builderTwo.get("indexStatusType").get("indexStatusTypeId").equal(1).or(exp);
and then get the result of expression expTow, but also i get the only the result of equal(1). although when i get the equal(null) or isNull() only in a get statement it work, but if i or it with another expression it return the another value not the null one.
i think the problem in or, may be the or here between object of type IndexStatusType and indexStatusTypeId which is long