Hi, you have find some tips on pattern matching here: http://orientdb.com/pattern-matching-with-orientdb/
http://orientdb.com/docs/last/SQL-Match.html Il giorno venerdì 9 settembre 2016 17:53:28 UTC+2, William ha scritto: > > 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.
