[orientdb] Re: [HELP] Order by date not working
Which version are you using? Il giorno martedì 29 novembre 2016 14:18:25 UTC+1, Academia Learning Centro de inglés y de formación ha scritto: > > I have tried with this query and I get this results (not ordered): > > *select value.uid.value as id, value.context.start_time.value as date* > *from CompositionVersions order by value.context.start_time.value desc > limit 5* > > id > date > fe9e6036 > 2014-02-23T12:33:10.000+01:00 > 80eee423 > 2014-03-08T11:35:25.000+01:00 > 0600c7bd > 2014-01-27T22:49:36.000+01:00 > 291c1e1e > 2014-03-08T04:28:15.000+01:00 > a8b7d7c9 > 2014-01-04T03:31:02.000+01:00 > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: [HELP] Order by date not working
please try with select value.uid.value as id, value.context.start_time.value as date from CompositionVersions order by date desc limit 5 Il giorno martedì 29 novembre 2016 14:18:25 UTC+1, Academia Learning Centro de inglés y de formación ha scritto: > > I have tried with this query and I get this results (not ordered): > > *select value.uid.value as id, value.context.start_time.value as date* > *from CompositionVersions order by value.context.start_time.value desc > limit 5* > > id > date > fe9e6036 > 2014-02-23T12:33:10.000+01:00 > 80eee423 > 2014-03-08T11:35:25.000+01:00 > 0600c7bd > 2014-01-27T22:49:36.000+01:00 > 291c1e1e > 2014-03-08T04:28:15.000+01:00 > a8b7d7c9 > 2014-01-04T03:31:02.000+01:00 > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: [HELP] Order by date not working
This says the console: OrientDB console v.2.2.12-SNAPSHOT (build 2.2.x@r2a76ee1efc4487d9dc5f43e1ddc2fba 1c5a0167c; 2016-10-20 13:55:08+) www.orientdb.com Type 'help' to display all the supported commands. Installing extensions for GREMLIN language v.2.6.0 El martes, 29 de noviembre de 2016, 14:39:03 (UTC+1), Oleksandr Gubchenko escribió: > > Which version are you using? > > Il giorno martedì 29 novembre 2016 14:18:25 UTC+1, Academia Learning > Centro de inglés y de formación ha scritto: >> >> I have tried with this query and I get this results (not ordered): >> >> *select value.uid.value as id, value.context.start_time.value as date* >> *from CompositionVersions order by value.context.start_time.value desc >> limit 5* >> >> id >> date >> fe9e6036 >> 2014-02-23T12:33:10.000+01:00 >> 80eee423 >> 2014-03-08T11:35:25.000+01:00 >> 0600c7bd >> 2014-01-27T22:49:36.000+01:00 >> 291c1e1e >> 2014-03-08T04:28:15.000+01:00 >> a8b7d7c9 >> 2014-01-04T03:31:02.000+01:00 >> >> -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: [HELP] Order by date not working
Thanks, this works El martes, 29 de noviembre de 2016, 23:05:48 (UTC+1), Ivan Mainetti escribió: > > please try with > > select value.uid.value as id, value.context.start_time.value as date from > CompositionVersions order by date desc limit 5 > > > > >> -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.