SubQuery not working any help ?

Skip to first unread message

David Laberge

Aug 31, 2015, 10:25:08 AM8/31/15
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
0 new messages