Hi guys,
yes, having just a few lines of result will help a lot, I'm just trying to
figure out the exact "physical" structure of your records to see if there
is something I'm missing.
Could you please also try this and let me know if you get the expected
results?
select expand(in("CompetitionEntry__competition").out("
CompetitionEntry__roster").in("plays_for")) from #{@competition.id} LIMIT
-1
Thanks
Luigi
2015-08-26 16:53 GMT+02:00 Brandon Dennis <[email protected]>:
> CompetitionEntry__competition is a lightweight edge.
> CompetitionEntry__roster and plays_for are both document backed edges.
>
> Running the last query gives me CompetitionEntry, the middle query gives
> me Rosters, and the first query gives me the plays_for edges.
>
> We're still on 1.7 because we're using this from a jruby application, that
> has a gem that wraps the java jars, and another gem that modeled after an
> old Neo4j gem version to access Orient. My predecessors wrote both gems,
> and there are a lot of exceptions that get thrown when I try to run it with
> 2.x version of orient.
>
>
> On Tuesday, August 25, 2015 at 2:05:08 PM UTC-4, Brandon Dennis wrote:
>>
>> 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.
