Hi guys. Apologies for the newbie question but two of us have been trying to figure out how to query the ‘CarId’ property on the edge called ‘UsedOn’ to determine the following with no luck:
*Who are all the people that use a wrench on a Mercedes?* Here is the script to create the sample db: create class Car extends V create vertex Car set name='Mercedes' create class Mechanic extends V create vertex Mechanic set firstName=‘Andy’, lastName=‘Miller’ create vertex Mechanic set firstName = ‘Billy’, lastName = ‘Edwards’ create class Tool extends V create vertex Tool set name=‘Wrench’ create class WorksOn extends E create edge WorksOn from (select from Mechanic where firstName=‘Billy’) to (select from Car where name=‘Mercedes’) create class UsesTool extends E create edge UsesTool from (select from Mechanic where firstName='Billy') to (select from Tool where name='Wrench') set CarId = (select @Rid from Car where name='Mercedes') We've tried googling similar examples but there doesn't seem to be in depth documentation about querying based on edge properties (or we're just not googling the right search phrase). That said, any help is greatly appreciated. -- --- 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/groups/opt_out.
