0
votes

I have one vertex connected to other vertices as:

B1 <------E1------ A1 ------E2------> B2
      name=name1        name=name2

Vertex A1 of class A has several properties. Edges E1 and E2 are of class and each have a name property.

I want a query to return Vertex A1 but with a map of the connected vertices' rids as keys and the name on their respective edge as values.

I.e, I want to return:

{
    <all of vertex A1's normal properties>,
    connected: {
        <ridB1>: name1,
        <ridB2>: name2 
    }
}

I know how to return this:

{
    <all of vertex A1's normal properties>,
    names: ["name1", "name2"],
    rids: ["ridB1", "ridB2"]
}

By doing:

SELECT *, out("E")[@rid] as rids, outE("E")[name] as names from #14:0

But I can't seem to be able to build the map I would like from the two lists.

1
Hi dargolith, which version of orientdb you have? - ldacrema
@ldacrema I would like to use the newest version released as docker image. - dargolith

1 Answers

0
votes

Try this:

select @rid, name from E where outV().name LIKE "%A1%"

this is what I get:

enter image description here

Hope it helps

Regards