Ah, by the way, why are you sticking to 1.7? Last versions are much much more stable and performing
Luigi 2015-08-26 8:26 GMT+02:00 Luigi Dell'Aquila <[email protected]>: > Hi James, > > are you using lightweight edges (do you have properties on edges?). In v > 1.7 it was the default, so maybe you just do not have edge documents in > your db. > Could you please try these and post the results? > > select expand(inE('plays_for')) from (traverse > out("CompetitionEntry__roster") from (traverse > in("CompetitionEntry__competition") > from #{@competition.id})) > > traverse out("CompetitionEntry__roster") from (traverse > in("CompetitionEntry__competition") from #{@competition.id}) > > traverse in("CompetitionEntry__competition") from #{@competition.id} > > > Thanks > > Luigi > > 2015-08-25 19:39 GMT+02:00 Brandon Dennis <[email protected]>: > >> For reference I'm using 1.7.9 in jruby (but I stole the studio.zip from >> 2.1 and put it in the plugins directory, hence the graph editor). Also I >> didn't write this query (or codebase) I inherited it. >> >> I have a query that should start at a Competition, traverse to all >> CompetitionEntries via the CompetitionEntry__competition, then to the >> Rosters via the CompetitionEntry__roster and finally get all the >> 'plays_for' edges. Here is the query: >> >> "select from (select expand(inE('plays_for')) from (traverse >> out_CompetitionEntry__roster from (traverse >> in_CompetitionEntry__competition from #{@competition.id})))" >> >> Below is a screenshot of the graph editor showing the relationships. >> There are a lot more than this, but this was mainly for reference. >> >> >> <https://lh3.googleusercontent.com/-uf2aek6jakg/VdynV2qMOcI/AAAAAAAAAJg/wlJiJtiJ7uU/s1600/Screen%2BShot%2B2015-08-25%2Bat%2B1.26.03%2BPM.png> >> >> This query returns a lot of data, but it doesn't return everything I >> expect it to. It actually wont return any of the 'plays_for' edges shown >> above. I'm not sure what I'm missing. Is there a reason the above query's >> response wouldn't include the data shown in the screenshot? >> >> -- >> >> --- >> 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. >> > > -- --- 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.
