Retrieve multi-level relations

[rostaingc]

I have three objects:

• Page
• PageTable
• TableColumn

A page can contain multiple tables, a table can contain multiple columns

@Entity('pages')
@ObjectType()
@UnPagedRelation('pageTables', () => Table)
export class Page {
  @PrimaryColumn({ type: 'text' })
  @Field()
  id: string;

  @Column({ type: 'text' })
  @Field()
  name: string;

  @OneToMany(() => PageTable, (t) => t.page)
  pageTables?: R<PageTable>[];
}

@Entity('page_tables')
@ObjectType()
@UnPagedRelation('tableColumns', () => TableColumn)
export class PageTable {
  @PrimaryColumn({ type: 'text' })
  @Field()
  id: string;

  @Column({ type: 'text' })
  @Field()
  name: string;

  @Column({ type: 'text' })
  @Field()
  pageID: Page['id'];

  @ManyToOne(() => Page)
  @JoinColumn({ name: 'pageID' })
  page: Relation<Page>;

  @OneToMany(() => TableColumn, (c) => c.table)
  tableColumns?: Relation<TableColumn>[];
}

@Entity('table_columns')
@ObjectType()
export class TableColumn {
  @PrimaryColumn({ type: 'text' })
  @Field()
  id: string;

  @Column({ type: 'text' })
  @Field()
  name: string;

  @Column({ type: 'text' })
  @Field()
  tableID: PageTable['id'];

  @ManyToOne(() => PageTable)
  @JoinColumn({ name: 'tableID' })
  pageTable: Relation<PageTable>;
}

I am querying the page through graphql and am trying to get the following:

page(id: $id) {
  id
  name
  pageTables {
    id
    name
    tableColumns {
      id
      name
    }
  }
}

I am only able to retrieve the page and its tables
The columns are not appearing in my schema inside the PageTable class.

I have create a single Module:

@Module({
  imports: [
    NestjsQueryGraphQLModule.forFeature({
      imports: [NestjsQueryTypeOrmModule.forFeature([Page, PageTable, TableColumn])],
      resolvers: [
        {
          DTOClass: Page,
          EntityClass: Dashboard,
          pagingStrategy: PagingStrategies.NONE,
        },
      ],
    }),
  ],
})
export class PageModule {}

Is it possible to fetch 2-level deep relations ?

[rostaingc]

Ok I have found that the issue is coming from the absence of declaration of PageTable and TableColumn in the resolvers of my module