Hi, I do not understand, could you give an example? The version property of my object is not @version
El viernes, 25 de noviembre de 2016, 22:14:54 (UTC+1), Oleksandr Gubchenko escribió: > > Maybe you should use @version > > Il giorno venerdì 25 novembre 2016 14:54:53 UTC+1, Aceitunas y encurtidos > Quijote ha scritto: >> >> I've tried this but it does not work either. >> >> SELECT FROM CompositionVersions LET >> $temp = (select max(version) from CompositionVersions) >> WHERE $temp = version >> >> El viernes, 25 de noviembre de 2016, 9:48:53 (UTC+1), Aceitunas y >> encurtidos Quijote escribió: >>> >>> Hi, I want to retrieve the latest version of each Composition object. >>> >>> *select from CompositionVersions where version = (select max(version) >>> from CompositionVersions)* >>> >>> But this not working. >>> >>> 1-Is there another more efficient way to recover the latest version, >>> without knowing the number of versions that there are? >>> 2-Would it be convenient to save in the Composition object, an attribute >>> with the id of the latest version? >>> >>> >> -- --- 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.