Open BenStirrup opened 2 years ago
There is an error at the level of the ORM : QueryFailedError: operator does not exist: text[] ~~ unknown.
QueryFailedError: operator does not exist: text[] ~~ unknown
// DB schema field @Column('text', { array: true, default: [UserRole.EMPLOYEE] }) roles: UserRole[] // Contraint type in filter / or { field: 'roles', operator: CondOperator.CONTAINS, value: UserRole.EMPLOYER }
We should be able to filter on array fields.
Modify the SQL generated when the field is an array.
Bug Report
Current behavior
There is an error at the level of the ORM :
QueryFailedError: operator does not exist: text[] ~~ unknown.Input Code
Expected behavior
We should be able to filter on array fields.
Possible Solution
Modify the SQL generated when the field is an array.
Environment