Nested relationships

[adnathanail]

Hi just wondering if you can help?

My schema looks like this:

db.version(6).stores({
      route: 'id,name',
      journey: 'id,date,route -> route.id',
      fare: 'id',
      stop: 'id,name,route -> route.id',
      time_set: 'id,stop -> stop.id',
      departure: 'id,journey -> journey.id,time_set -> time_set.id',
    });

And I am trying to make a query like this:

this._dexieService.departure
              .filter((departure): boolean => {
                return departure.journey === journey_id;
              })
              .with({
                journey: 'journey',
                time_set: 'time_set',
                time_set__stop: 'stop',
              });

But that last line in the with is obviously not working (One of a number of different syntaxes I've tried). Essentially I want to have an object inside an object inside an object, to represented the 3-level nested relationship between departures->time_sets->stops (and then also ->routes)

Just wondering if it is at all possible to have this kind of output?

[dfahlander]

Unfortunately, dexie-relationships does only work in one level relations.

[adnathanail]

Ah OK thanks anyway

[justin-hackin]

Please consider loudly announcing this lack of support in your documentation. By chance, I noticed this and saved myself lot of wasted time but I'm concerned others like the poster might not.