I appreciate the suggestion however hat doesn't seem to output the desired
behavior.
When I run:
select *, GetAncestors(@rid) as Ancestors from Person order by Name
I get the following:
{
"result": [
{
"@type": "d",
"@rid": "#-2:0",
"@version": 0,
"rid": "#22:0",
"Name": "Frank",
"Ancestors": [
],
"@fieldTypes": "rid=x"
},
{
"@type": "d",
"@rid": "#-2:1",
"@version": 0,
"rid": "#22:1",
"Name": "Bob",
"Ancestors": [
"#22:0"
],
"@fieldTypes": "rid=x"
},
{
"@type": "d",
"@rid": "#-2:2",
"@version": 0,
"rid": "#22:2",
"Name": "Dave",
"Ancestors": [
"#22:0"
],
"@fieldTypes": "rid=x"
},
{
"@type": "d",
"@rid": "#-2:3",
"@version": 0,
"rid": "#22:3",
"Name": "Chad",
"Ancestors": [
"#22:1",
"#22:0"
],
"@fieldTypes": "rid=x"
}
],
"notification": "Query executed in 0.296 sec. Returned 4 record(s)"
}
What I would like is:
{
"result": [
{
"@type": "d",
"@rid": "#-2:0",
"@version": 0,
"rid": "#22:0",
"Name": "Frank",
"Ancestors": [],
"@fieldTypes": "rid=x"
},
{
"@type": "d",
"@rid": "#-2:1",
"@version": 0,
"rid": "#22:1",
"Name": "Bob",
"Ancestors": [
{
"@type": "d",
"@rid": "#-2:0",
"@version": 0,
"rid": "#22:0",
"Name": "Frank",
"Ancestors": [],
"@fieldTypes": "rid=x"
}
],
"@fieldTypes": "rid=x"
},
{
"@type": "d",
"@rid": "#-2:2",
"@version": 0,
"rid": "#22:2",
"Name": "Dave",
"Ancestors": [
{
"@type": "d",
"@rid": "#-2:0",
"@version": 0,
"rid": "#22:0",
"Name": "Frank",
"Ancestors": [],
"@fieldTypes": "rid=x"
}
],
"@fieldTypes": "rid=x"
},
{
"@type": "d",
"@rid": "#-2:3",
"@version": 0,
"rid": "#22:3",
"Name": "Chad",
"Ancestors": [
{
"@type": "d",
"@rid": "#-2:0",
"@version": 0,
"rid": "#22:0",
"Name": "Frank",
"Ancestors": [],
"@fieldTypes": "rid=x"
},
{
"@type": "d",
"@rid": "#-2:1",
"@version": 0,
"rid": "#22:1",
"Name": "Bob",
"Ancestors": [
"#22:0"
],
"@fieldTypes": "rid=x"
}
],
"@fieldTypes": "rid=x"
}
],
"notification": "Query executed in 0.296 sec. Returned 4 record(s)"
}
When I run your suggestion:
select expand(Ancestors) from (select GetAncestors(@rid) as Ancestors from
Person order by name)
I get:
{
"result": [
{
"@type": "d",
"@rid": "#-2:0",
"@version": 0,
"rid": "#22:0",
"Name": "Frank",
"Ancestors": [
],
"@fieldTypes": "rid=x"
},
{
"@type": "d",
"@rid": "#-2:0",
"@version": 0,
"rid": "#22:0",
"Name": "Frank",
"Ancestors": [
],
"@fieldTypes": "rid=x"
},
{
"@type": "d",
"@rid": "#-2:1",
"@version": 0,
"rid": "#22:1",
"Name": "Bob",
"Ancestors": [
"#22:0"
],
"@fieldTypes": "rid=x"
},
{
"@type": "d",
"@rid": "#-2:0",
"@version": 0,
"rid": "#22:0",
"Name": "Frank",
"Ancestors": [
],
"@fieldTypes": "rid=x"
}
],
"notification": "Query executed in 0.287 sec. Returned 4 record(s)"
}
On Friday, August 14, 2015 at 11:57:19 AM UTC-4, [email protected] wrote:
>
> Hi Chris,
>
> Try this:
>
> select expand(Ancestors) from (select GetAncestors(@rid) as Ancestors from
> Person order by name)
>
> Regards,
> Michela
>
--
---
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.
