Filtering does not work on embedded fields

[Marko298]

If I try to filter query by field in embedding I receive 500 error. Request /farms?filter=customerStatus.feedAccountNumber||$eq||8999996

Error [Nest] 52408 - 03/15/2021, 12:44:12 PM [ExceptionsHandler] ER_BAD_FIELD_ERROR: Unknown column 'customerStatus.feedAccountNumber' in 'where clause' +114696ms QueryFailedError: ER_BAD_FIELD_ERROR: Unknown column 'customerStatus.feedAccountNumber' in 'where clause'

Farm Class

@Entity('farms')
export class Farm {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  name: string;

  @Column(() => CustomerInfo)
  customerStatus: CustomerInfo;

  @CreateDateColumn()
  createdAt: Date;

  @UpdateDateColumn()
  updatedAt: Date;
}

CustomerInfo class

export class CustomerInfo {
  @Column({
    type: 'enum',
    enum: FeedCustomerStatus,
    default: FeedCustomerStatus.INACTIVE,
  })
  feedStatus?: FeedCustomerStatus;

  @Column({ nullable: true })
  feedAccountNumber?: string;

  @Column({
    type: 'enum',
    enum: PulletCustomerStatus,
    default: PulletCustomerStatus.INACTIVE,
  })
  pulletStatus: PulletCustomerStatus;

  @Column({ nullable: true })
  pulletAccountNumber?: string;

  @Column({ nullable: true })
  accountName?: string;
}

I tried join, alias, nothing helped

[Manokero]

How does look your @Crud({...}) At the farmController?

[Marko298]

@Crud({
  model: {
    type: Farm,
  },

  dto: {
    create: FarmDto,
    update: PartialType(FarmDto),
  },

  query: {
    limit:          25,
    maxLimit:       100,
    alwaysPaginate: true,
    join:           {
      tags:                { eager: true, allow: ['id', 'name', 'color'] },
      teams:               { eager: true, allow: ['id', 'name'] },
      customerStatus:      { eager: true },
    },

    sort: [{ field: 'name', order: 'ASC' }],
  },
})

[chf007]

If I try to filter query by field in embedding I receive 500 error. Request /farms?filter=customerStatus.feedAccountNumber||$eq||8999996

Error [Nest] 52408 - 03/15/2021, 12:44:12 PM [ExceptionsHandler] ER_BAD_FIELD_ERROR: Unknown column 'customerStatus.feedAccountNumber' in 'where clause' +114696ms QueryFailedError: ER_BAD_FIELD_ERROR: Unknown column 'customerStatus.feedAccountNumber' in 'where clause'

Farm Class

@Entity('farms')
export class Farm {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  name: string;

  @Column(() => CustomerInfo)
  customerStatus: CustomerInfo;

  @CreateDateColumn()
  createdAt: Date;

  @UpdateDateColumn()
  updatedAt: Date;
}

CustomerInfo class

export class CustomerInfo {
  @Column({
    type: 'enum',
    enum: FeedCustomerStatus,
    default: FeedCustomerStatus.INACTIVE,
  })
  feedStatus?: FeedCustomerStatus;

  @Column({ nullable: true })
  feedAccountNumber?: string;

  @Column({
    type: 'enum',
    enum: PulletCustomerStatus,
    default: PulletCustomerStatus.INACTIVE,
  })
  pulletStatus: PulletCustomerStatus;

  @Column({ nullable: true })
  pulletAccountNumber?: string;

  @Column({ nullable: true })
  accountName?: string;
}

I tried join, alias, nothing helped

Excuse me, has this problem been resolved later? How to solve it?

[applicature-mark-boychuk]

I just created fields that mirrored content of embedded ones. I don't know whether this was fixed or not

[chf007]

I just created fields that mirrored content of embedded ones. I don't know whether this was fixed or not

This is a way, thank you

[applicature-mark-boychuk]

This is how I did it

[sofia-cloudman]

I have the same problem here, is there any other solutions? it seems ugly to use a BeforeInsert and duplicate fields :(