SubQuery not working any help ?

[David Laberge]

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