I have a Word vertex type with value and freq properties and followedBy 
edge type which connects Words together. I also defined an index `
indexWordValue` on Word 'value' property and `indexFollowedBy_in` on the 
edge's `in` property.

I need to use a subquery to get the values to be searched against my words 
index:

select from index:indexFollowedBy_in where Key in (select from 
index:indexWordValue 
where Key='Test')

But I get this message:

java.lang.ClassCastException: com.orientechnologies.orient.core.sql.query.
OSQLSynchQuery cannot be cast to com.orientechnologies.orient.core.db.record
.OIdentifiable

I also tried these but no luck:
select from index:indexFollowedBy_in where Key = (select rid.asString() from 
index:indexWordValue where Key='Test')

select (select from index:indexFollowedBy_in where Key = $a) let $a = (
select flatten(rid) from index:indexWordValue where key='Test')

Is this supported in OrientDB? if yes how?

-- 

--- 
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.

Reply via email to