0

How do I query the DB and get an AttendanceReport with all association data (LeaderAttending and PersonAttending)? Not just RID's that I do with a regular select from AttendanceReport.

Or should I use links for this kind of data?

I am a newbie to OrientDB, graph and document databases.

create class Person extends V
create class Leader extends Person
create class AttendanceReport extends V
create class HasLeader extends E
create class LeaderAttending extends E
create class PersonAttending extends E

create property Person.name string
create property AttendanceReport.meetingDate datetime

create vertex Person set name='Billy'
create vertex Person set name='Jane'
create vertex Leader set name='Boss'
create vertex AttendanceReport set meetingDate='2015-09-25 11:00:00'

create edge HasLeader from (select from Person where name='Billy') to (select from Leader where name='Boss')

create edge HasLeader from (select from Person where name='Jane') to (select from Leader where name='Boss')

create edge LeaderAttending from (select from AttendanceReport limit 1) to (select from Leader where name='Boss')

create edge PersonAttending from (select from AttendanceReport limit 1) to (select from Person where name='Jane')
Markus Hedlund
  • 23,374
  • 22
  • 80
  • 109

1 Answers1

1

You could do this query

select in.name,out.meetingDate from (select expand(outE('LeaderAttending','PersonAttending')) from AttendanceReport  )
wolf4ood
  • 1,939
  • 10
  • 8