How to query array from a querybuild in AdonisJs?

Question

I have an object whose column refers to a Json type.

How do I perform a query inside the Json column using id for example?

Model

 @column({
    prepare: (value: Array<object>) => JSON.stringify(value),
    consume: (value: string) => JSON.parse(value),
  })
  public armazenado: object

Controller

const items = await Armazempredio.query().select('*')
      .with('armazenado', builder => {
        builder.where(Database.raw(`JSON_CONTAINS(id, '["0001"]')`))
      })

marcelo.delta · Accepted Answer · 2022-03-23 22:48:12Z

1

Resolver with

@column({
    prepare: (value: Array<object>) => JSON.stringify(value),
    consume: (value: string) => JSON.parse(value),
  })

answered Mar 23, 2022 at 22:48

marcelo.delta

3,1027 gold badges48 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to query array from a querybuild in AdonisJs?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related