Error in query with FilterableRelation

[mborgues]

I I would like to know what the problem is with the query with filter by relationship below, the objects are mapped and related but I get the error attached:

query {
  servicosDiaria(
    paging: { limit: 1000 }
    filter: {
      escalaDiaria: {
        codigoIntLinha: { eq: 321 }
        dataEscala: { eq: "2021-10-04T00:00:00.000Z" }
      }
    }
    sorting: [{ field: codigoServicoDiario, direction: ASC }]
  ) {
    nodes {
      codigoServicoDiario
    }
  }
}

Error:

Error: unknown operator "codigoIntEscala"
at SQLComparisonBuilder.build (D:\Praxio\GlobusWeb\packages\query-typeorm\src\query\sql-comparison.builder.ts:93:11)
at (D:\Praxio\GlobusWeb\packages\query-typeorm\src\query\where.builder.ts:143:37)
at Array.map ()
at Brackets.whereFactory (D:\Praxio\GlobusWeb\packages\query-typeorm\src\query\where.builder.ts:142:37)
at SelectQueryBuilder.getWhereCondition (D:\Praxio\GlobusWeb\node_modules\typeorm\query-builder\src\query-builder\QueryBuilder.ts:1626:19)
at SelectQueryBuilder.andWhere (D:\Praxio\GlobusWeb\node_modules\typeorm\query-builder\src\query-builder\SelectQueryBuilder.ts:1183:29)
at WhereBuilder.withFilterComparison (D:\Praxio\GlobusWeb\packages\query-typeorm\src\query\where.builder.ts:139:18)
at (D:\Praxio\GlobusWeb\packages\query-typeorm\src\query\where.builder.ts:109:21)
at Array.reduce ()
at WhereBuilder.filterFields (D:\Praxio\GlobusWeb\packages\query-typeorm\src\query\where.builder.ts:107:32)

[TriPSs]

Could you share the model (Database and DTO)

[mborgues]

sources.zip

I checked that when I entered this code, it doesn't have anything related when the field is a relation, it searches for the comparison identifier, which doesn't exist in this case because it is an object:

build(field, cmp, val, alias) {
        const col = this.getCol(field, alias);
        const normalizedCmp = cmp.toLowerCase();
        if (this.comparisonMap[normalizedCmp]) {
            // comparison operator (e.b. =, !=, >, <)
            return this.createComparisonSQL(normalizedCmp, col, val);
        }
        if (normalizedCmp === 'is') {
            // is comparison (IS TRUE, IS FALSE, IS NULL)
            return this.isComparisonSQL(col, val);
        }
        if (normalizedCmp === 'isnot') {
            // is comparison (IS NOT TRUE, IS NOT FALSE, IS NOT NULL, etc...)
            return this.isNotComparisonSQL(col, val);
        }
        if (normalizedCmp === 'in') {
            // in comparison (field IN (1,2,3))
            return this.inComparisonSQL(col, val);
        }
        if (normalizedCmp === 'notin') {
            // in comparison (field IN (1,2,3))
            return this.notInComparisonSQL(col, val);
        }
        if (normalizedCmp === 'between') {
            // between comparison (field BETWEEN x AND y)
            return this.betweenComparisonSQL(col, val);
        }
        if (normalizedCmp === 'notbetween') {
            // notBetween comparison (field NOT BETWEEN x AND y)
            return this.notBetweenComparisonSQL(col, val);
        }
        throw new Error(`unknown operator ${JSON.stringify(cmp)}`);
    }

[mborgues]

I'm so sorry, i found my error in the name of relation with the property in entity

[mborgues]

Taking advantage, is there anything you can tell me to do in Oracle date type fields, because queries that have any filter or relationship with dates do not return the data, in these DTOS and entities the configurations made do not work, but I have already tried others as well without success, thank you!