[
https://issues.apache.org/jira/browse/CXF-7848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mitesh Panchal updated CXF-7848:
--------------------------------
Description:
Upon supplying null as argument to field in FIQL, CXF generated Query does not
return any results.
e.g. _s=city==null or _s=city!=null does not return any results. while
leveraging JPATypedQueryVisitor which build criteria query.
found couple of instances where this issue is discussed or resolved.
e.g. [https://github.com/jirutka/rsql-parser/issues/21] : talks about add a new
operator as an option
or [https://github.com/jirutka/rsql-parser] solves the issue by looking at the
argument and creating a criteria builder query with help of
builder.isNull(exp); or builder.isNotNull(exp); statements.
Please let us know what can be done?
Workaround I have applies for temporary is as below
{code:java}
/** Enhanced AbstractSearchConditionVisitor.java method doBuildPredicate **//
private Predicate doBuildPredicate(ConditionType ct, Path<?> path, Class<?>
valueClazz, Object value) {
.
.
case EQUALS:
if (clazz.equals(String.class)) {
if(value.toString().equalsIgnoreCase("null")){
pred = builder.isNull(exp);
}else if(value.toString().equalsIgnoreCase("notNull")){
pred = builder.isNotNull(exp);
}else{
final String originalValue = value.toString();
String theValue = SearchUtils.toSqlWildcardString(originalValue,
isWildcardStringMatch());
if (SearchUtils.containsWildcard(originalValue)) {
if (SearchUtils.containsEscapedChar(theValue)) {
pred = builder.like((Expression<String>)exp, theValue,
'\\');
} else {
pred = builder.like((Expression<String>)exp,
theValue);
}
} else {
pred = builder.equal(exp, clazz.cast(value));
}
}
} else {
pred = builder.equal(exp, clazz.cast(value));
}
.
.
.
{code}
was:
Upon suppling null as argument to field in FIQL no results found.
e.g. _s=city==null or _s=city!=null does not return any results. while
leveraging JPATypedQueryVisitor which build criteria query.
found couple of instances where this issue is discussed or resolved.
e.g. [https://github.com/jirutka/rsql-parser/issues/21] : talks about add a new
operator as an option
or [https://github.com/jirutka/rsql-parser] solves the issue by looking at the
argument and creating a criteria builder query with help of
builder.isNull(exp); or builder.isNotNull(exp); statements.
Please let us know what can be done?
Workaround I have applies for temporary is as below
{code:java}
/** Enhanced AbstractSearchConditionVisitor.java method doBuildPredicate **//
private Predicate doBuildPredicate(ConditionType ct, Path<?> path, Class<?>
valueClazz, Object value) {
.
.
case EQUALS:
if (clazz.equals(String.class)) {
if(value.toString().equalsIgnoreCase("null")){
pred = builder.isNull(exp);
}else if(value.toString().equalsIgnoreCase("notNull")){
pred = builder.isNotNull(exp);
}else{
final String originalValue = value.toString();
String theValue = SearchUtils.toSqlWildcardString(originalValue,
isWildcardStringMatch());
if (SearchUtils.containsWildcard(originalValue)) {
if (SearchUtils.containsEscapedChar(theValue)) {
pred = builder.like((Expression<String>)exp, theValue,
'\\');
} else {
pred = builder.like((Expression<String>)exp,
theValue);
}
} else {
pred = builder.equal(exp, clazz.cast(value));
}
}
} else {
pred = builder.equal(exp, clazz.cast(value));
}
.
.
.
{code}
> JPATypedQueryVisitor does not support isNull or isNotNull JPA operation
> -----------------------------------------------------------------------
>
> Key: CXF-7848
> URL: https://issues.apache.org/jira/browse/CXF-7848
> Project: CXF
> Issue Type: Bug
> Components: JAX-RS
> Affects Versions: 3.2.6
> Reporter: Mitesh Panchal
> Priority: Major
>
> Upon supplying null as argument to field in FIQL, CXF generated Query does
> not return any results.
> e.g. _s=city==null or _s=city!=null does not return any results. while
> leveraging JPATypedQueryVisitor which build criteria query.
> found couple of instances where this issue is discussed or resolved.
> e.g. [https://github.com/jirutka/rsql-parser/issues/21] : talks about add a
> new operator as an option
> or [https://github.com/jirutka/rsql-parser] solves the issue by looking at
> the argument and creating a criteria builder query with help of
> builder.isNull(exp); or builder.isNotNull(exp); statements.
> Please let us know what can be done?
> Workaround I have applies for temporary is as below
>
> {code:java}
> /** Enhanced AbstractSearchConditionVisitor.java method doBuildPredicate **//
> private Predicate doBuildPredicate(ConditionType ct, Path<?> path, Class<?>
> valueClazz, Object value) {
> .
>
> .
> case EQUALS:
> if (clazz.equals(String.class)) {
> if(value.toString().equalsIgnoreCase("null")){
> pred = builder.isNull(exp);
> }else if(value.toString().equalsIgnoreCase("notNull")){
> pred = builder.isNotNull(exp);
> }else{
> final String originalValue = value.toString();
> String theValue =
> SearchUtils.toSqlWildcardString(originalValue,
> isWildcardStringMatch());
> if (SearchUtils.containsWildcard(originalValue)) {
> if (SearchUtils.containsEscapedChar(theValue)) {
> pred = builder.like((Expression<String>)exp,
> theValue, '\\');
> } else {
> pred = builder.like((Expression<String>)exp,
> theValue);
> }
> } else {
> pred = builder.equal(exp, clazz.cast(value));
> }
> }
> } else {
> pred = builder.equal(exp, clazz.cast(value));
> }
> .
> .
> .
>
> {code}
>
>
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
