dates in app engine java

[Joan Torres]

When I try to order a query in app engine java, by date, I find that it does not order the query correctly.

This is the case I have:

three records the first one has the date like this 10/09/2019 (09:21:00) 

the second like this 10/09/2019 (12:20:12) and 

the third one is like this 10/09/2019 (13:28:00)

but the order given by app engine is the opposite

first 10/09/2019 (12:20:12) 

second 10/09/2019 (09:21:00) 

third 10/09/2019 (13:28:00)

When the correct way to do the query is:

First 10/09/2019 (09:21:00) 

second 10/09/2019 (12:20:12) 

third 10/09/2019 (13:28:00)

I have tried in several ways but I can't find a solution, I appreciate your help to improve this process.

[George (Cloud Platform Support)]

Hello Joan, 

How did you perform the query? Do you refer to com.google.appengine.api.datastore Class Query? There is a Enum Query.SortDirection. Did you use Cloud SQL? 

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching App Engine and Cloud SQL. For query order by issues you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help. 

[Joan Torres]

Hi Jorge, thank you very much for the guidance, I have already created the post on stackoverflow.

https://stackoverflow.com/questions/58330683/not-returns-dates-well-into-java-app-engine

This is the filter that I am applying and the ordering of the date in the offspring

List operationList = ofy().load().type(Operation.class).filter(compositeFilter).order("-date").order("-codeOperation").list();

El jueves, 10 de octubre de 2019, 10:50:03 (UTC-5), George (Cloud Platform Support) escribió:

Hola joan 

¿Cómo realizó la consulta? ¿Te refieres a com.google.appengine.api? consulta de clase del almacén de datos ? Hay una Enum Query.SortDirection. ¿Usaste Cloud SQL? 

Este grupo de discusión está más orientado hacia opiniones generales, tendencias y cuestiones de naturaleza general que afectan a App Engine y Cloud SQL. Para el orden de las consultas por problemas, es posible que reciba un mejor servicio en foros dedicados como stackoverflow, donde los programadores experimentados están al alcance y listos para ayudar.