[news.eclipse.rt.eclipselink] Expressions query generated property but e

[rahul.thakur.xdev@xxxxxxxxx (Rahul Thakur)]

Greetings,

I am using Expressions framework to dynamically build queries. However, I 
notice from logs that though the query generated is valid (returns 
expected results when I run it from DB console),  it does not return any 
results when run via JPA.

There are no errors on anything and I am wondering if there is anything 
else I can try to investigate this further. 

Here's the snippet:
 ReadObjectQuery query = new ReadObjectQuery(Project.class);
 query.setFirstResult(0);
 query.setMaxRows(100);
 ExpressionBuilder project = query.getExpressionBuilder();
 Expression exp = null;

 if (null != this.projectNameNumber
      && !this.projectNameNumber.trim().equals("")) {
	exp = project.get("name").like("%" + this.projectNameNumber + 
"%").or(project.get("code").like("%" + this.projectNameNumber + "%"));
 }

 if (null != this.workOrderNumber && 
!this.workOrderNumber.trim().equals(""))  {
   Expression subExp = project.anyOf("workOrders").get("code")
						.like("%" + this.workOrderNumber + "%");
   if (null == exp)
	exp = subExp;
   else
	exp = exp.and(subExp);
 }

 if (null != this.projectStartDate) {
   Expression subExp = 
project.get("startDate").greaterThan(this.projectStartDate);
   if (null == exp)
	exp = subExp;
   else
	exp = exp.and(subExp);
 }

 List<Project> results = store.queryByExample(Project.class, 0, 10, exp);
 // Zero size list obtained!

Here's the generated query :
SELECT DISTINCT t0.ID, t0.OBJ_VERSION, t0.START_DATE, t0.END_DATE, 
t0.PROJECT_CODE, t0.DATE_UPDATED, t0.FLG_IS_ACTIVE, 
t0.PROJECT_DESCRIPTION, t0.PROJECT_NAME, t0.DATE_CREATED, 
t0.ID_CLIENT_USER, t0.ID_COMPANY FROM PROJECT t0, WORK_ORDER t1 WHERE 
(((((t0.PROJECT_NAME LIKE ?) OR (t0.PROJECT_CODE LIKE ?)) AND 
(t1.WORK_ORDER_CODE LIKE ?)) AND (t0.START_DATE > ?)) AND (t1.ID_PROJECT = 
t0.ID))
	bind => [%GEN%, %GEN%, %M7%, 2009-12-12]


Look forward to hear...

Many thanks,

Rahul