Incorrect WHERE condition generation on related record

[mborgues]

I have an entity that has a relationship, I made all the configurations as usual in entities and DTOs, but the select to search for relationships is being generated with the WHERE incorrectly, I was unable to find the reason, below is the data:

error: Error: ORA-00904: "AGRUPAMENTOOCORRENCIASOCORRENCIAS"."CODIGOAGRUPAMENTO": identificador inválido
query failed: SELECT DISTINCT "bc7e0f4b0a993a0942870cd5acaa2"."TIPOAGROCORR" AS "9016ea0575c5bfd2b0208fa088a85", "bc7e0f4b0a993a0942870cd5acaa2"."CODAGRUP" AS "8373401effa2f7b981453dbc7164b", "bc7e0f4b0a993a0942870cd5acaa2"."CODOCORR" AS "78896283b6038588c68fd8b80b856" FROM "FRQ_AGRUPAOCORR_OCORR" "bc7e0f4b0a993a0942870cd5acaa2" WHERE agrupamentoOcorrenciasOcorrencias.tipoAgrupamento IN (:1) AND agrupamentoOcorrenciasOcorrencias.codigoAgrupamento IN (:2) FETCH NEXT 11 ROWS ONLY -- PARAMETERS: [100,1]

--Main query
SELECT "AgrupamentoOcorrenciaEntity"."TIPOAGROCORR" AS "c7b4bf07418801879023b0009cdb2", "AgrupamentoOcorrenciaEntity"."CODAGRUP" AS "ca01aafaade2706daedb3affd5f74", "AgrupamentoOcorrenciaEntity"."DESCAGRUP" AS "323f60a24d271ec6dde704136578d", "AgrupamentoOcorrenciaEntity"."CODOCORR_VLR" AS "fc196f4e2a58a7317637687bab2f2", "AgrupamentoOcorrenciaEntity"."NAODESCONTARTICKET_DOM" AS "3fbf1d5da21b1436ad46a10cbb3db", "AgrupamentoOcorrenciaEntity"."NAODESCONTARTICKET_SEG" AS "e7d868067cdb869245694ff3abf04", "AgrupamentoOcorrenciaEntity"."NAODESCONTARTICKET_TER" AS "4e1529687341a76e535147c522325", "AgrupamentoOcorrenciaEntity"."NAODESCONTARTICKET_QUA" AS "7f3b7561a5af107b643d91e420ccf", "AgrupamentoOcorrenciaEntity"."NAODESCONTARTICKET_QUI" AS "9824bd5a5b0978c955d2c5c65acfc", "AgrupamentoOcorrenciaEntity"."NAODESCONTARTICKET_SEX" AS "5c124417368d78d38c9e0270709b5", "AgrupamentoOcorrenciaEntity"."NAODESCONTARTICKET_SAB" AS "0f1c104202ca65262137f8f699d8f" FROM "FRQ_AGRUPAOCORR" "AgrupamentoOcorrenciaEntity" WHERE ("AgrupamentoOcorrenciaEntity"."TIPOAGROCORR" = :1) FETCH NEXT 11 ROWS ONLY -- PARAMETERS: [100]

--Relation query
query: SELECT DISTINCT "bc7e0f4b0a993a0942870cd5acaa2"."TIPOAGROCORR" AS "9016ea0575c5bfd2b0208fa088a85", "bc7e0f4b0a993a0942870cd5acaa2"."CODAGRUP" AS "8373401effa2f7b981453dbc7164b", "bc7e0f4b0a993a0942870cd5acaa2"."CODOCORR" AS "78896283b6038588c68fd8b80b856" FROM "FRQ_AGRUPAOCORR_OCORR" "bc7e0f4b0a993a0942870cd5acaa2" WHERE agrupamentoOcorrenciasOcorrencias.tipoAgrupamento IN (:1) AND agrupamentoOcorrenciasOcorrencias.codigoAgrupamento IN (:2) FETCH NEXT 11 ROWS ONLY -- PARAMETERS: [100,1]

query failed: SELECT DISTINCT "bc7e0f4b0a993a0942870cd5acaa2"."TIPOAGROCORR" AS "9016ea0575c5bfd2b0208fa088a85", "bc7e0f4b0a993a0942870cd5acaa2"."CODAGRUP" AS "8373401effa2f7b981453dbc7164b", "bc7e0f4b0a993a0942870cd5acaa2"."CODOCORR" AS "78896283b6038588c68fd8b80b856" FROM "FRQ_AGRUPAOCORR_OCORR" "bc7e0f4b0a993a0942870cd5acaa2" WHERE agrupamentoOcorrenciasOcorrencias.tipoAgrupamento IN (:1) AND agrupamentoOcorrenciasOcorrencias.codigoAgrupamento IN (:2) FETCH NEXT 11 ROWS ONLY -- PARAMETERS: [100,1]

//agrupamento-ocorrencia.entity.ts
import { Entity, PrimaryColumn, Column, ManyToOne, OneToMany, JoinColumn } from 'typeorm';
import { OcorrenciaEntity } from './ocorrencia.entity';
import { AgrupamentoOcorrenciaOcorrenciaEntity } from './agrupamento-ocorrencia-ocorrencia.entity';
import { AutoMap } from '@automapper/classes';

@Entity('FRQ_AGRUPAOCORR')
export class AgrupamentoOcorrenciaEntity {
  @PrimaryColumn({ name: 'TIPOAGROCORR', type: 'number', precision: 3 })
  @AutoMap()
  tipoAgrupamento: number;

  @PrimaryColumn({ name: 'CODAGRUP', type: 'number', precision: 3 })
  @AutoMap()
  codigoAgrupamento: number;

  @Column({ name: 'DESCAGRUP', type: 'varchar', length: 60, nullable: true })
  @AutoMap()
  descricaoAgrupamento?: string;

  ...

  @ManyToOne(() => OcorrenciaEntity, (ocorrencia) => ocorrencia.agrupamentoOcorrencia)
  @JoinColumn({ name: 'CODOCORR_VLR', referencedColumnName: 'codigoOcorrencia' })
  @AutoMap()
  ocorrencia?: OcorrenciaEntity;

  @OneToMany(() => AgrupamentoOcorrenciaOcorrenciaEntity, (agrupamentoOcorrenciaOcorrencia) => agrupamentoOcorrenciaOcorrencia.agrupamentoOcorrencia)
  agrupamentoOcorrenciasOcorrencias: AgrupamentoOcorrenciaOcorrenciaEntity[];

}


//agrupamento-ocorrencia-ocorrencia.entity.ts
import { Entity, PrimaryColumn, OneToMany, JoinColumn, ManyToOne } from 'typeorm';
import { AutoMap } from '@automapper/classes';
import { AgrupamentoOcorrenciaEntity, OcorrenciaEntity } from '@/entities';

@Entity('FRQ_AGRUPAOCORR_OCORR')
export class AgrupamentoOcorrenciaOcorrenciaEntity {
  @PrimaryColumn({ name: 'TIPOAGROCORR', type: 'number', precision: 3 })
  @AutoMap()
  tipoAgrupamento: number;

  @PrimaryColumn({ name: 'CODAGRUP', type: 'number', precision: 3 })
  @AutoMap()
  codigoAgrupamento: number;

  @PrimaryColumn({ name: 'CODOCORR', type: 'number', precision: 3 })
  @AutoMap()
  codigoOcorrencia: number;

  @OneToMany(() => OcorrenciaEntity, (ocorrencia) => ocorrencia.agrupamentoOcorrencia)
  @AutoMap()
  ocorrencias: OcorrenciaEntity[];

  @ManyToOne(() => AgrupamentoOcorrenciaEntity, (agrupamentoOcorrencia) => agrupamentoOcorrencia.agrupamentoOcorrenciasOcorrencias)
  @JoinColumn([
    { name: 'TIPOAGROCORR', referencedColumnName: 'tipoAgrupamento' },
    { name: 'CODAGRUP', referencedColumnName: 'codigoAgrupamento' },
  ])
  agrupamentoOcorrencia: AgrupamentoOcorrenciaEntity;

}

//return-agrupamento-ocorrencia.dto.ts
import { ObjectType, Directive } from '@nestjs/graphql';
import { AutoMap } from '@automapper/classes';
import { IsNumber, IsOptional, IsString, Length, Matches } from 'class-validator';
import { IDField, FilterableField, FilterableRelation, FilterableOffsetConnection } from '@ptc-org/nestjs-query-graphql';
import { IdAgrupamentoOcorrencia } from '../id/id-agrupamento-ocorrencia.input';
import { ReturnOcorrenciaDTO } from './return-Ocorrencia.dto';
import { ReturnAgrupamentoOcorrenciaOcorrenciaDTO } from './return-agrupamento-ocorrencia-ocorrencia.dto';

@ObjectType('AgrupamentoOcorrencia')
@FilterableRelation('ocorrencia', () => ReturnOcorrenciaDTO, { nullable: true })
@FilterableOffsetConnection('agrupamentoOcorrenciasOcorrencias', () => ReturnAgrupamentoOcorrenciaOcorrenciaDTO, { nullable: true })
@Directive('@key(fields: "tipoAgrupamento codigoAgrupamento")')
export class ReturnAgrupamentoOcorrenciaDTO {
  @IDField(() => IdAgrupamentoOcorrencia)
  get idAgrupamentoOcorrencia(): IdAgrupamentoOcorrencia {
    return {
      tipoAgrupamento: this.tipoAgrupamento,
      codigoAgrupamento: this.codigoAgrupamento
    };
  }
  
  @AutoMap()
  @IsNumber()
  @FilterableField(() => Number)
  tipoAgrupamento: number;

  @AutoMap()
  @IsNumber()
  @FilterableField(() => Number)
  codigoAgrupamento: number;

  @FilterableField({ nullable: true })
  @AutoMap()
  @IsString()
  @IsOptional()
  @Length(0, 60)
  descricaoAgrupamento?: string;

  ...

  @FilterableField()
  @AutoMap()
  @IsString()
  @Matches(/^[NS]$/)
  descontarTicketSabado: string;
  
}

//return-agrupamento-ocorrencia-ocorrencia.dto.ts
import { AutoMap } from "@automapper/classes";
import { Directive, Int, ObjectType } from "@nestjs/graphql";
import { FilterableField, FilterableOffsetConnection, FilterableRelation, IDField} from '@ptc-org/nestjs-query-graphql';
import { ReturnOcorrenciaDTO } from "./return-Ocorrencia.dto";
import { IdAgrupamentoOcorrenciaOcorrencia } from "../id/id-agrupamento-ocorrencia-ocorrencia.input";
import { ReturnAgrupamentoOcorrenciaDTO } from "./return-agrupamento-ocorrencia.dto";

@ObjectType('AgrupamentoOcorrenciaOcorrencia')
@FilterableOffsetConnection('ocorrencias', () => ReturnOcorrenciaDTO, { nullable: true})
@FilterableRelation('agrupamentoOcorrencia', () => ReturnAgrupamentoOcorrenciaDTO, { nullable: true })
@Directive('@key(fields: "tipoAgrupamento codigoAgrupamento codigoOcorrencia")')
export class ReturnAgrupamentoOcorrenciaOcorrenciaDTO {
    @AutoMap()
    @FilterableField(() => Int)
    codigoAgrupamento: number;
  
    @AutoMap()
    @FilterableField(() => Int)
    tipoAgrupamento: number;

    @AutoMap()
    @FilterableField(() => Int)
    codigoOcorrencia: number;

    @IDField(() => IdAgrupamentoOcorrenciaOcorrencia)
    get idAgrupamentoOcorrenciaOcorrencia(): IdAgrupamentoOcorrenciaOcorrencia {
      return {
        codigoAgrupamento: this.codigoAgrupamento,
        tipoAgrupamento: this.tipoAgrupamento,
        codigoOcorrencia: this.codigoOcorrencia
      }      
    }
}

[mborgues]

After analysis, I found that the origin of the problem is related to the number of characters in the name property of the FilterableOffSetConnection decorator, and after changing "agrupamentoOcorrenciasOcorrencias" to "agrupOcorrenciasOcorrencias", the WHERE condition was generated correctly, I did not identify whether the origin occurs in nest-query or in TypeORM, but the number of characters in this property will interfere in the generation of the condition.