I want to select all records returned by shortestPath. So I am using a subquery like so:
SELECT expand(shortestPath) from (SELECT shortestPath(#11:25989,#11:3953,"Both"))
In Studio that returns what I would expect:
{
"result": [
{
"@type": "d",
"@rid": "#11:346",
"@version": 1,
"@class": "Character",
"char_id": 2149,
"in_Enemy": [
"#14:206",
"#14:487",
"#14:1199",
"#14:1777",
(And a whole bunch more)
But the same query in Oriento via
db.query('SELECT expand(shortestPath) from (select shortestPath(#11:346,#11:13138,"Both"))').then(function(path){
console.log(path);
return res.json(200, path);
});
Returns a much smaller and less useful object:
[{"@rid":"#11:346"},{"@rid":"#11:1045"},{"@rid":"#11:4870"},{"@rid":"#11:13138"}]
What's going on? How do I get at the full result from Oriento? Do I have to select each rid directly?