Dear Team,
Please clarify as what am I missing towards query in getEjbql():
String searchId = '%'+issuesId.toUpperCase()+'%';
String query = " where timesheets.workLog.issues.issueId like \'"+searchId+"\' or "+"timesheets.workLog.tasks.taskId like \'"+searchId+"\' ";
return "select timesheets from Timesheets timesheets "+query;
It throws:
Caused by: javax.el.ELException: /TimesheetsList.xhtml @80,56 rendered="#{empty timesheetsList.resultList}": Error reading 'resultList' on type org.domain.Portal.session.TimesheetsList_$$_javassist_70
at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:370)
... 55 more
Caused by: java.lang.NullPointerException
at org.hibernate.hql.ast.tree.FromClause.findIntendedAliasedFromElementBasedOnCrazyJPARequirements(FromClause.java:120)
Referred:
http://seamframework.org/Community/JBossSeamEnitityQueryAndRestrictionsAndOrOperationInTheQuery
http://seamframework.org/Community/EntityQueryWithRestrictionsProblem#comment75589
Note: Using seam 2.0.1 SP1
IssueId and TaskId are Strings.
Thank you in advance!