Request JPG application date

Question

Suppose I have an object that represents TASK. The task has a deadline.

How to create a request to get all the tasks that must be completed today?

Some working code, for example

"select t from task t, where dueDate =: today"

will be helpful.

Thanks in advance.

Answer 1

You assume that @Temporal is supported by the Google GAE / J plugin. This is not true despite being reported more than a year ago by http://code.google.com/p/datanucleus-appengine/issues/detail?id=20&colspec=ID%20Stars%20Type%20Status%20Priority%20FoundIn% 20TargetRelease% 20Owner% 20Summary

Answer 2

Assuming your dueDate is Date annotated as follows:

 @Temporal(TemporalType.DATE) private Date dueDate; 

Then you can execute the following query in JPQL:

 select t from Task where t.dueDate = current_date