1 reply

rqbv2 query where column = null

drizzle ormpostgres-js

Hi all, I have a simple schema and I want to check if the value is null via query.

However, it returns a type error saying cannot convert undefined or null to object.

TS2322: Type null is not assignable to type RelationsFieldFilter<Date> | undefined

TS2322: Type null is not assignable to type RelationsFieldFilter<Date> | undefined

export const dataTable = pgTable('dataTable', {
  deletedAt: timestamp('deleted_at', { withTimezone: true })
});

export const dataTable = pgTable('dataTable', {
  deletedAt: timestamp('deleted_at', { withTimezone: true })
});

const results = await db.query.dataTable.findMany({
  where: { deletedAt: null}, //TS2322
})

const results = await db.query.dataTable.findMany({
  where: { deletedAt: null}, //TS2322
})

I am expecting to be able to query for a null value, as I have not defined .notNull() in my table

This code below works fine

const results = await db
  .select()
  .from(dataTable)
  .where(isNull(dataTable.deletedAt))

const results = await db
  .select()
  .from(dataTable)
  .where(isNull(dataTable.deletedAt))

Have I done something wrong here?

Drizzle Team•4w ago•

1 reply

kyoumei

rqbv2 query where column = null

drizzle ormpostgres-js

Hi all, I have a simple schema and I want to check if the value is null via query.

However, it returns a type error saying cannot convert undefined or null to object.

TS2322: Type null is not assignable to type RelationsFieldFilter<Date> | undefined

TS2322: Type null is not assignable to type RelationsFieldFilter<Date> | undefined

export const dataTable = pgTable('dataTable', {
  deletedAt: timestamp('deleted_at', { withTimezone: true })
});

export const dataTable = pgTable('dataTable', {
  deletedAt: timestamp('deleted_at', { withTimezone: true })
});

const results = await db.query.dataTable.findMany({
  where: { deletedAt: null}, //TS2322
})

const results = await db.query.dataTable.findMany({
  where: { deletedAt: null}, //TS2322
})

I am expecting to be able to query for a null value, as I have not defined .notNull() in my table

This code below works fine

const results = await db
  .select()
  .from(dataTable)
  .where(isNull(dataTable.deletedAt))

const results = await db
  .select()
  .from(dataTable)
  .where(isNull(dataTable.deletedAt))

Have I done something wrong here?

rqbv2 query where column = null

Similar Threads

rqbv2 query where column = null

Similar Threads

Similar Threads

Similar Threads