Thanks for your reply, you helped me to find the answer. Yes, I had to 
think from the opposite direction of the edge, i.e.

select from ATS_NAMAbbr where dval like "ABS%"

and then get the vertices, instances of ETSAbbr, (shortname Abbreviation) 
by expanding the in() of LTSval

select expand(in_LTSval) from ATS_NAMAbbr where dval like "ABS%"

There is no need to define an index although this will improve speed.

On Monday, 18 July 2016 18:51:45 UTC+3, SavioL wrote:
>
> You can use this query:
>
> select expand(in('LTSval')) from ATS_NAMAbbr where dval LUCENE "ABS*"
>
>

-- 

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