I solved it like this
Select email, last(profile_picture.filename) from User where username =
'tom'
Is this the most efficient way though?
On Monday, 22 June 2015 22:36:02 UTC+1, Thomas Kennedy wrote:
>
> I have a class User below and I'm storing profile pictures as a linkedlist
> to another class called ProfilePicture.
>
>
> I want to return all the columns in User and the last entry in the
> profile_picture.
>
>
> Any ideas how this query would look?
>
>
>
> [ { '@type': 'd',
>
> '@class': 'User',
>
> username: 'tom',
>
> email: 't...@tom.com',
>
> profile_picture: [ [Object] ],
>
> id: '#13:0' }
>
> ]
>
--
---
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.
