I can't expand more than three times in let query. what is the alternative way?

24 views
Skip to first unread message

Pugazharasan Thirumalai

unread,
Dec 19, 2016, 4:41:50 AM12/19/16
to OrientDB
If i execute the below query,

select sum($service.gross_value) as total from #25:1073 let $service = (select expand(out('store_has_billing')['is_deleted = false']) from (select expand(out('network_has_store')['is_deleted = false']) from $parent.$current))

am get result.

But if i expand again, then am not getting answer,

select sum($service.gross_value) as total from #25:1073 let $service = (select expand(out('billing_has_billing_services')) from (select expand(out('store_has_billing')['is_cancel = false']['is_deleted = false']) from (select expand(out('network_has_store')['is_deleted = false']) from $parent.$current)))

Any please give suggestion or alternative way for this?

Oleksandr Gubchenko

unread,
Dec 19, 2016, 8:33:02 AM12/19/16
to OrientDB
Are you using the latest version?
Reply all
Reply to author
Forward
0 new messages