Hi Simon, What's the meaning of using the WHERE with a fixed target like #40:123?
However, in order to help you, could you show us the real class name of vertices and edges used? Best Regards, Luca Garulli Founder & CEO OrientDB <http://orientdb.com/> On 5 August 2015 at 00:54, Simon White <[email protected]> wrote: > Simplifying further still, even this does not work... > > *select in('town_has_zipcode')[0].zip as test from #40:123 where test = > 'LA90019'* > > > > > On Tuesday, August 4, 2015 at 11:47:52 PM UTC+1, Simon White wrote: >> >> I know I am being stupid but could anyone help me with a simple select >> statement spanning multiple edges? >> >> >> I have a model which looks like PERSON -> TOWN <- ZIPCODE >> >> I am trying to select all the people that live in a named zip code but I >> am getting no matches... >> >> *select out('person_lives_in_town').in('town_has_zipcode')[0].zip from >> person where zip= 'LA90019'* >> >> if I do *select from town where zip = 'LA90019'* it returns the single >> zip vertex as expected >> if I do *select >> out('person_lives_in_town').in('town_has_zipcode')[0].zip* from person >> it returns a list of zip code names as expected >> >> (Note: I am unable to reverse the query to travel from zip codes back to >> people (which logically may make more sense) because the real model is >> actually a bit more complicated and various timestamps are involved, >> hopefully this is a good enough demonstration example though) >> > -- > > --- > 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. > -- --- 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.
