Hi Alessandro,
Yeah, I saw that this morning... it solved the problem. Ivan's solution
was this:
SELECT Date, Weight, list(B_ID)[0] as B1_ID, list(B_ID)[1] as B2_ID,
list(A_Flag)[0]
as A1_Flag, list(A_Flag)[1] as A2_Flag
FROM
(
MATCH {class: C, AS: C, WHERE: (Weight>0.9 AND
Date.format('yyyy-MM')='2014-09')}.out('E2')
{as: B}.in('E1') {as: A, where: ($matched.C.Date=$currentMatch.Date)}
RETURN C, C.Date AS Date, C.Weight AS Weight, B.ID, A.Flag
)
GROUP BY C
I haven't seen the array style notation in my reading so far... Where would
I look in the docs to read up on what he was doing with the list(B_ID)[0]
pieces
of the query?
Thanks!
-William
On Friday, September 9, 2016 at 6:34:46 AM UTC-6, [email protected]
wrote:
>
> Hi,
> have you seen the aswer by Ivan Mainetti at this link
> <http://stackoverflow.com/questions/39401396/orientdb-query-to-return-matched-paths-satisfying-constraints-in-tabular-form>
> ?
>
> Best regards,
> Alessandro
>
--
---
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.
