SubQuery not working any help ?

25 views
Skip to first unread message

David Laberge

unread,
Aug 31, 2015, 10:25:08 AM8/31/15
to orient-...@googlegroups.com
Hi all,

I'm working with the following request to our DB (Orient 2.1 - document DB). The subQuery on its own works. The Query with out the condition "createdDate.asLong() >= $t.d" works as well, returning the expected value if added to the SELECT section. And copying the result of the subQuery in the where clause the query actually works as well. What am I missing?

select * from Currency let $t = (select createdDate.asLong() as d from 13:1) where createdDate.asLong() >= $t.d and  @rid <> #13:1 order by createdDate ASC
Reply all
Reply to author
Forward
0 new messages