OffSetConnection does not return values

[mborgues]

Hello, how can I check why the records in my child table are not returning? In one of my DTOs I did all the configuration of the connection relationship between the DTOs. I see that the respective selects are executed in the database but only the main DTO is returned without the related data. I have already made other relationships and they are returning normally, but one in particular is not. Here are my classes and the query I am performing, and what am I missing?

Entities:

//vericulo.entity.ts
import { AutoMap } from '@automapper/classes';
import { Entity, Column, PrimaryColumn, OneToMany } from 'typeorm';
import { TransferenciaVeiculoEntity } from './transferencia-veiculo.entity';

@Entity('FRT_CADVEICULOS')
export class VeiculoEntity {
  @AutoMap()
  @PrimaryColumn({ type: 'number', name: 'CODIGOVEIC' })
  codigoVeiculo: number;

  ...

  @AutoMap()
  @Column({ type: 'varchar2', length: 50, nullable: true, name: 'RENAVANVEIC' })
  renavamVeiculo: string;

  @AutoMap()
  @Column({ type: 'varchar2', length: 50, nullable: true, name: 'TELEFONE_CHIP_DOIS' })
  telefoneChipDois: string;

  @OneToMany(() => TransferenciaVeiculoEntity, transferencia => transferencia.veiculo)  
  transferencias?: TransferenciaVeiculoEntity[];
}

//transferencia-veiculo.entity.ts
import { Entity, Column, PrimaryColumn, ManyToOne, JoinColumn } from 'typeorm';
import { AutoMap } from '@automapper/classes';
import { VeiculoEntity } from './veiculo.entity';
import { Transform } from 'class-transformer';

@Entity('FRT_TRANSFERENCIAVEIC')
export class TransferenciaVeiculoEntity {
  @AutoMap()
  @PrimaryColumn({ type: 'number', name: 'CODIGOVEIC' })
  codigoVeiculo: number;

  @AutoMap()
  @PrimaryColumn({ type: 'date', name: 'DATATRANSVEIC'})
  @Transform(({ value }) => value ? new Date(value) : value, { toClassOnly: true })
  dataTransferencia: Date;

  @AutoMap()
  @PrimaryColumn({ type: 'timestamp', name: 'HORATRANSVEIC',
    transformer: {
      to: (value: Date) => {
        // Converte a data para UTC antes de salvar no banco
        //const offset = value.getTimezoneOffset();
        //return new Date(value.getTime() + offset * 60000);
        return value;
      },
      from: (value: Date) => {
        // Converte a data de UTC para o fuso horário local ao recuperar
        const offset = new Date().getTimezoneOffset();
        return new Date(value.getTime() - offset * 60000);
      },
    },
  })
  horaTransferencia: Date;

  ...

  @AutoMap()
  @Column({ type: 'number', name: 'CODIGOTPFROTAATUAL', nullable: true })
  codigoTipoFrotaAtual?: number;

  @ManyToOne(() => VeiculoEntity, veiculo => veiculo.transferencias)
  @JoinColumn({ name: 'CODIGOVEIC' })
  veiculo: VeiculoEntity;
}

//return-veiculo.dto.ts
import { AutoMap } from "@automapper/classes";
import { Directive, Field, ID, Int, ObjectType } from "@nestjs/graphql";
import { FilterableField, IDField, OffsetConnection } from "@ptc-org/nestjs-query-graphql";
import { ReturnTransferenciaVeiculoDTO } from "./return-transferenciaVeiculo.dto";

@ObjectType("Veiculo")
@OffsetConnection('transferencias', () => ReturnTransferenciaVeiculoDTO, { nullable: true })
@Directive('@key(fields:"codigoVeiculo")')
export class ReturnVeiculoDTO {
  @AutoMap()
  @IDField(() => ID)
  codigoVeiculo: number;

  ...

  @Field({ nullable: true })
  @AutoMap()
  aceitaMovimentacaoVendaVeiculo: string;

  @Field({ nullable: true })
  @AutoMap()
  renavamVeiculo: string;

  @Field({ nullable: true })
  @AutoMap()
  telefoneChipDois: string;
}

//return-transferenciaVeiculo.dto.ts
import { ObjectType, Int, Directive, GraphQLISODateTime } from '@nestjs/graphql';
import { AutoMap } from '@automapper/classes';
import { FilterableField, FilterableRelation, IDField } from '@ptc-org/nestjs-query-graphql';
import { IdTransferenciaVeiculoInput } from '../input/id-transferenciaVeiculo.input';
import { ReturnVeiculoDTO } from './return-veiculo.dto';

@ObjectType('TransferenciaVeiculo')
@FilterableRelation('veiculo', () => ReturnVeiculoDTO, { nullable: true })
@Directive('@key(fields: "codigoVeiculo dataTransferencia horaTransferencia")')
export class ReturnTransferenciaVeiculoDTO {

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

  @AutoMap()
  @FilterableField(() => GraphQLISODateTime)
  dataTransferencia: Date;

  @AutoMap()
  @FilterableField(() => GraphQLISODateTime)
  horaTransferencia: Date;

  ...

  @IDField(() => IdTransferenciaVeiculoInput)
  get idTransferenciaVeiculo(): IdTransferenciaVeiculoInput {
    return {
      codigoVeiculo: this.codigoVeiculo,
      dataTransferencia: this.dataTransferencia,
      horaTransferencia: this.horaTransferencia
    }
  }
}

queries:

[GP4cK]

The best is if you could clone the repo and recreate the issue with one of the examples. It makes it easier to run the code and investigate.

[mborgues]

I think this situation is related to entities/DTOs with a composite key, as graphql can only have one IDField, I created an object that has all the entity's key fields, the search by ID correctly returns the data, but relationships with DTOs with not this type of key.

[mborgues]

I recreated the implementation using SQLite to reproduce the example. In database has the same records of my post.

nest-query.zip