DatastoreService ds =
DatastoreServiceFactory.getDatastoreService();
Query query = new Query("Table1");
query.addFilter("cid", Query.FilterOperator.EQUAL, 1111l);
// was not very clear documented how dates are saved in DB
// query.addFilter("ctime",
Query.FilterOperator.GREATER_THAN_OR_EQUAL, "DATE(2009, 12, 1)");
// query.addFilter("ctime",
Query.FilterOperator.GREATER_THAN_OR_EQUAL, new Date(2009, 12, 1));
query.addFilter("ctime",
Query.FilterOperator.GREATER_THAN_OR_EQUAL,
new Date(2009, 12, 1).getTime());
query.addSort("ctime");
query.setKeysOnly();
FetchOptions options = FetchOptions.Builder.withLimit(1000);
PreparedQuery p1 = ds.prepare(query);
Iterable it = p1.asIterable(options);
I hope it will help someone.
On Jan 16, 12:53 pm, Max <[email protected]> wrote:
> Hi, I can't write JDO query but I can make that query in GQL
>
> SELECT __key__ FROM Table1 WHERE cid = 1111 and ctime >= DATE
> ('2009-12-1') ORDER BY ctime LIMIT 1000
>
> ------
>
> Query query = pm.newQuery("SELECT FROM " +
> Table1.class.getName()
> + " WHERE cid == cid1 && ctime >=
> ctime1 "
> + " parameters Long cid1,
> java.util.Date ctime1 "
> + " order by ctime "
> + " RANGE 0, 10 ");
> List ids = (List) query.execute(1111l, new Date(2009, 12, 1));
>
> JDO return nothing and error when I try something like
>
> Query query = pm.newQuery("SELECT key FROM " +
> Table1.class.getName
> ()
> + " WHERE cid == cid1 && ctime >=
> ctime1 "
> + " parameters Long cid1,
> java.util.Date ctime1 "
> + " order by ctime "
> + " RANGE 0, 10 ");
> List ids = (List) query.execute(1111l, new Date(2009, 12, 1));
>
> or
>
> Query query = pm.newQuery("SELECT __key__ FROM " +
> Table1.class.getName()
> + " WHERE cid == cid1 && ctime >=
> ctime1 "
> + " parameters Long cid1,
> java.util.Date ctime1 "
> + " order by ctime "
> + " RANGE 0, 10 ");
> List ids = (List) query.execute(1111l, new Date(2009, 12, 1));
>
> Primary Key is "key"
>
> Cheers, Max
--
You received this message because you are subscribed to the Google Groups
"Google App Engine for Java" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-appengine-java?hl=en.
