I am getting the following error: Inconsistent column data: Could not convert value "110015 " of the field

ClientNumber

to type

Int

. The database has a ClientNumber, but it's a string with spaces at the end. I can convert the Parameter to an int, but it doesn't work. Controller:

@Get(`${Route}/client/:id`)
  byclient(@Param('id') id: number  ) {
    let tempID  = id.toString();
    tempID = tempID.slice(0,6);
    return this.MatterService.MatterbyClient(+tempID);
  }

I have also tried:

@Get(`${Route}/client/:id`)
  byclient(@Param('id') id: string  ) {
    let tempID = id.slice(0,6);
    return this.MatterService.MatterbyClient(+tempID);
  }

Service:

MatterbyClient( clientid: any) {
    return Promise.all([
      this.prisma.matter.findMany({
        where: { ClientNumber: clientid  },
        select: defaultSelectQuery
      })
  }

Schema:

model Matter {
  MatterPKID              Int       @id @default(autoincrement())
  ClientNumber            String    @db.VarChar(16)
  MatterNumber            String    @db.VarChar(16)
  MatterUno               Int
  ClientUno               Int
  MatterName              String    @db.VarChar(250)
  MatterDescription       String?   @db.VarChar(Max)
  OpenDate                DateTime? @db.Date
  CloseDate               DateTime? @db.Date
  

  @@index([ApprovalDate], name: "ncl_Matter_ApprovalDate")
  @@index([ClientNumber], name: "ncl_Matter_ClientNumber")
}

I've tried setting the schema: ClientNumber Int but with no success.

Did you get it working?

Are you still facing the issue and are you on the latest version of

@prisma/client

?