Wow, that's easy :-) For those interested, I added a 'calculation' field using the functions part of Orientdb to get a score (x * y). I guess that's the way to go for calculated fields. (love it!)
thanks for your fast reply, Luigi <https://lh3.googleusercontent.com/-8ggu-Hf0l4Q/VXvOx9fIEpI/AAAAAAAAhYw/q_9gFA8cTg0/s1600/img1668.jpg> <https://lh3.googleusercontent.com/-i7-BrOv87Ik/VXvO8VHl-BI/AAAAAAAAhZA/GTjaqgOkrS4/s1600/img1669.jpg> On Friday, June 12, 2015 at 6:44:38 PM UTC+2, Luigi Dell'Aquila wrote: > > ah, I suggest you to define an index (NOTUNIQUE) on the score property, > this query will become extremely fast > > Luigi > > > 2015-06-12 18:43 GMT+02:00 Luigi Dell'Aquila <[email protected] > <javascript:>>: > >> Hi Marteen, >> >> the easiest thing you can do is this: >> >> select outV().name as personName, inV().name as taskName, score from >> Performs order by score DESC >> >> Luigi >> >> >> 2015-06-12 18:16 GMT+02:00 Maarten Berkenbosch <[email protected] >> <javascript:>>: >> >>> How do I join person.name, performs.score, task.name into one query >>> result that displays the top 10 scores? >>> Or should I assemble the list with multiple queries? >>> >>> (Vertex) Person.name >>> (Edge) Performs.score >>> (Vertex) Task.name >>> >>> -- >>> >>> --- >>> 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 [email protected] <javascript:>. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
