Hi all, I'm working with the following request to our DB (Orient 2.1). 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 -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
