Just to let you know the query...
I have two tables.
Users and UserSurveys
There is a one-to-many mapping between
Users to UserSurveys.
I'm trying to perform a query like to get users who haven't completed a survey
before 'purchaseDate':
Query query = entityManager.createQuery("FROM " + User.class.getSimpleName()
+ " cu LEFT JOIN FETCH
cu.userSurveys us"
+ " WHERE cu.purchaseDate <=
:purchaseDate");
query.setParameter("purchaseDate", new java.sql.Date(cal.getTimeInMillis()),
TemporalType.DATE);
That's it.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4083869#4083869
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4083869
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
