How to make a query with PostgreSQL and TypeORM) where a Table has a JSON Type Column

Question

How can I query from a JSON-type Column in PostgreSQL? Let's say following is my Entity witch contains the JSON-type column validDates:

// My Menu - Entity Class
@Entity()
export Class Menu {
  @PrimaryGeneratedColumn('uuid')
     id: string;
  @Column('json', {nullable: true})
    validDates?: ValidDatesClass;
}

// The ValidDatesClass
export class ValidDatesClass {
   [key: string]: boolean;
}

And I want to retrieve (SQL syntax) all Menus where validDates 's value is true (example of a validDates- entry: "Mon Aug 01 2018": true )

Does this answer your question? typeorm postgres select where json field equals some value — snakecharmerb
– snakecharmerb, Commented Jul 15, 2021 at 18:47

General Grievance · Accepted Answer · 2021-07-15 18:39:55Z

0

async getAllBrands() {
  return this.productsRepository
    .query(`SELECT properties->'brand' as brand from product`);
}

For more details: https://wanago.io/2020/12/28/nestjs-json-postgresql-typeorm/

edited Jul 15, 2021 at 18:39

General Grievance

5,12039 gold badges39 silver badges60 bronze badges

answered Jul 15, 2021 at 18:05

Moab Santos de Farias

1

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

Collectives™ on Stack Overflow

How to make a query with PostgreSQL and TypeORM) where a Table has a JSON Type Column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related