query object exceeds maximum depth when have multiple one to many relationships

[kpayson]

In my schema Tenants have multiple Clients and Clients have multiple Providers. When I write a query for tenants that includes Clients and includes the Providers inside the Clients I get a max depth exceeded error.

{"error":{"statusCode":400,"name":"Error","message":"The query object exceeds maximum depth 32","code":"QUERY_OBJECT_TOO_DEEP"}}  

I would really love to see this resolved. I have complex schema and need to write routines to export different subsets of the data. It will be quite hard to manually start to try to join the data together if I need to write multiplw queries and join the data together myself.

Here is the function that does the query:

  public async exportTenantData(
    @param.path.number('tenantId') tenantId: number
  ): Promise<any> {

    const inclusions = [
      {
        relation: 'clients',
        scope: {
          include: [
            {
              relation: 'providers',
              scope: {
                fields: { id: true }
              }
            },
          ]
        }
      },
    ];

    const filter = { include: inclusions };
    return this.tenantRepository.findById(tenantId, filter);
  }

[stale]

This issue has been marked stale because it has not seen activity within six months. If you believe this to be in error, please contact one of the code owners, listed in the CODEOWNERS file at the top-level of this repository. This issue will be closed within 30 days of being stale.

[stale]

This issue has been closed due to continued inactivity. Thank you for your understanding. If you believe this to be in error, please contact one of the code owners, listed in the CODEOWNERS file at the top-level of this repository.