Thanks Luigi for your help. The main query returns 50k+ records of results
so it might be hard to post. The first query seems to have returned the
same results as our existing one. Would posting you a small amount of
results work? Don't know specifically what you are looking for. Let me know
as we are trying to get this solved ASAP.
On Wednesday, August 26, 2015 at 2:27:02 AM UTC-4, Luigi Dell'Aquila wrote:
>
> 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] <javascript:>>:
>
>> 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] <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.
