My replies take a long time to get posted here since I'm new.
My application is written in Java and instance class of my app is F4. There
are a total of 922,758 entities of that Kind in the Datastore.
Here's the function:
public static Map <String , Object> getEntitiesUsingQueryCursor( String kind ,
int limit , int chunkSize , String currentCursor, String account, String user,
Boolean status, String dept ) throws Exception
{
String nextCursor = null;
Entity entity = null;
List <Entity> listOfEntity = new ArrayList <Entity>();
Map <String , Object> result = new HashMap <String , Object>();
DatastoreService datastore =
DatastoreServiceFactory.getDatastoreService();
com.google.appengine.api.datastore.Query q = new
com.google.appengine.api.datastore.Query( kind );
List <Filter> listOfFilter = new ArrayList <Filter>();
Filter filter1 = new FilterPredicate( "accountID" , FilterOperator.EQUAL ,
account);
Filter filter2 = new FilterPredicate( "assigneeID" , FilterOperator.EQUAL ,
user);
Filter filter3 = new FilterPredicate( "departmentID" , FilterOperator.EQUAL ,
dept);
Filter filter4 = new FilterPredicate( "open" , FilterOperator.EQUAL , status);
//Boolean
listOfFilter.add( filter1 );
listOfFilter.add( filter2 );
listOfFilter.add( filter3 );
listOfFilter.add( filter4 );
Filter filterParams1 = filterParams = CompositeFilterOperator.and( listOfFilter
);
q.setFilter( filter );
PreparedQuery pq = datastore.prepare( q );
FetchOptions fetchOptions =
FetchOptions.Builder.withLimit(limit).prefetchSize( chunkSize ).chunkSize(
chunkSize );// limit & chunksize - 500
if ( !StringUtil.isBlank( currentCursor ) )
fetchOptions.startCursor( Cursor.fromWebSafeString(
currentCursor ) );
QueryResultIterable <Entity> results = pq.asQueryResultIterable(
fetchOptions );
QueryResultIterator <Entity> iterator = results.iterator();
while ( iterator.hasNext() )
{
entity = iterator.next();
listOfEntity.add( entity );
}
if(listOfEntity.size() == limit)
nextCursor = iterator.getCursor().toWebSafeString();
result.put( "cursor" , nextCursor );
result.put( "entity" , listOfEntity );
return result;
}
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-appengine/1023920d-8691-4b2d-90ab-833413090524%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
