Select where version = max (), How would this be done?

[Aceitunas y encurtidos Quijote]

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?

 

[Aceitunas y encurtidos Quijote]

I've tried this but it does not work either.

SELECT FROM CompositionVersions LET 

$temp = (select max(version) from CompositionVersions)

WHERE $temp = version 

[Oleksandr Gubchenko]

Maybe you should use @version

[Aceitunas y encurtidos Quijote]

Hi, I do not understand, could you give an example?

The version property of my object is not @version

[Aceitunas y encurtidos Quijote]

I am trying with this query and it does not return anything:

select * from CompositionVersions where value.uid.value.split("::")[2] = (select max(value.uid.value.split("::")[2] ) from CompositionVersions)

This return the number 4:

select max(value.uid.value.split("::")[2] ) from CompositionVersions

This yes returns results

select * from CompositionVersions where value.uid.value.split("::")[2] = 4 

El viernes, 25 de noviembre de 2016, 9:48:53 (UTC+1), Aceitunas y encurtidos Quijote escribió:

[Aceitunas y encurtidos Quijote]

I have tried again with this query and now if it works:

select * from CompositionVersions where value.uid.value.split("::")[2] in (select max(value.uid.value.split("::")[2] ) from CompositionVersions)

it is right?

El viernes, 25 de noviembre de 2016, 9:48:53 (UTC+1), Aceitunas y encurtidos Quijote escribió: