HTTP Interface: result of query with exclude properties in select differs from those in studio

12 views
Skip to first unread message

hartmut bischoff

unread,
Apr 19, 2017, 3:15:59 PM4/19/17
to OrientDB
Hi,

while trying to avoid loading of embedded-maps by fetching a record via http#get tried the batch command.

Firing 

select expand( @this.exclude( 'portfolio_values','account_values')) from #140:0 

in Studio
gives the expected result: 
 
{
    "result": [
        {
            "@type": "d",
            "@rid": "#140:0",
            "@version": 164,
            "@class": "ib_account",
            "connected": "true",
            "account": "U797314",
            "created_at": "2017-04-14T19:58:09.200 02:00",
            "updated_at": "2017-04-19T17:45:03.772 02:00"
        }
    ],
    "notification": "Query executed in 0.03 sec. Returned 1 record(s)"
}

However, using the rest-api, the embedded records are fetched anyway:
 
batch: select expand( @this.exclude( 'portfolio_values','account_values')) from #140:0 
 => [{"@type"=>"d", "@rid"=>"#140:0", "@version"=>164, "@class"=>"ib_account", "account_values"=>{"ExcessLiquidity-S"=>{"@type"=>"d", "@version"=>0, "EUR"=>"23245.90"}, ...


Bug or expected behavior?

 I am using the server 2.2.15
Reply all
Reply to author
Forward
0 new messages