I have the following structure:
tournament{
"status": "today",
"tournament_id": 665,
"competitions": [
"#17:7991",
"#17:7992",
"#17:7993",
"#17:7994",
"#17:7995",
"#17:7996",
"#17:7997",
"#17:7998",
"#17:7999",
"#17:8000",
"#17:8001"
]
}
competition{
@rid: "#17:7991",
name: "some name",
comp_id: "154854",
comp_date: "2014-05-12",
season: "#15:2631"
}
season{
@rid: "#15:2631",
"name": "SPA",
"season_id": 665,
"round": "#14:152"
}
round{
@rid: "#14:152",
name="round one",
date="2014-12-18",
matches: [
"#17:8688",
"#17:8689",
"#17:8690",
"#17:8691",
"#17:8692",
"#17:8693",
"#17:8694",
"#17:8695",
"#17:8696",
"#17:8697",
"#17:8698",
]
}
match{
@rid: "#17:8688",
name: "some match 1",
date: "2014-12-18",
gameweek: "1"
}
match{
@rid: "#17:8689",
name: "some match 2",
date: "2014-12-26",
gameweek: "2"
}
I need a query which returns me only the tournament filled with all objects
holding matches of gameweek "1"
I have so many tournaments
each Tournament -> list<Competition> competitions -> Season -> Round ->
List<Match> matches
Any advise? I am using ObjectDB
--
---
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.
