Filter included relations

I am currently using the following query to retrieve all undeleted

appBundles

appBundles

from my database:

const selectedAppBundles = await db.query.appBundles.findMany({
  where: (appBundles, { isNull }) => isNull(appBundles.deletedAt),
  orderBy: (appBundles, { desc }) => desc(appBundles.createdAt),
  offset,
  limit,
  with: {
    appChannel: true,
  },
});

const selectedAppBundles = await db.query.appBundles.findMany({
  where: (appBundles, { isNull }) => isNull(appBundles.deletedAt),
  orderBy: (appBundles, { desc }) => desc(appBundles.createdAt),
  offset,
  limit,
  with: {
    appChannel: true,
  },
});

Each

appBundle

appBundle

can be assigned to an

appChannel

appChannel

. Currently, all undeleted

appBundles

appBundles

are returned, regardless of whether the associated

appChannel

appChannel

has been deleted or not. In the future, I only want to query

appBundles

appBundles

whose

appChannel

appChannel

is not deleted, if one is assigned.

Unfortunately, the following does not work:

const selectedAppBundles = await db.query.appBundles.findMany({
  where: (appBundles, { and, isNull }) => and(isNull(appBundles.deletedAt), isNull(appChannels.deletedAt)),
  orderBy: (appBundles, { desc }) => desc(appBundles.createdAt),
  offset,
  limit,
  with: {
    appChannel: true,
  },
});

const selectedAppBundles = await db.query.appBundles.findMany({
  where: (appBundles, { and, isNull }) => and(isNull(appBundles.deletedAt), isNull(appChannels.deletedAt)),
  orderBy: (appBundles, { desc }) => desc(appBundles.createdAt),
  offset,
  limit,
  with: {
    appChannel: true,
  },
});

What is the best way to implement this?

Filter included relations

I am currently using the following query to retrieve all undeleted

appBundles

appBundles

from my database:

const selectedAppBundles = await db.query.appBundles.findMany({
  where: (appBundles, { isNull }) => isNull(appBundles.deletedAt),
  orderBy: (appBundles, { desc }) => desc(appBundles.createdAt),
  offset,
  limit,
  with: {
    appChannel: true,
  },
});

const selectedAppBundles = await db.query.appBundles.findMany({
  where: (appBundles, { isNull }) => isNull(appBundles.deletedAt),
  orderBy: (appBundles, { desc }) => desc(appBundles.createdAt),
  offset,
  limit,
  with: {
    appChannel: true,
  },
});

Each

appBundle

appBundle

can be assigned to an

appChannel

appChannel

. Currently, all undeleted

appBundles

appBundles

are returned, regardless of whether the associated

appChannel

appChannel

has been deleted or not. In the future, I only want to query

appBundles

appBundles

whose

appChannel

appChannel

is not deleted, if one is assigned.

Unfortunately, the following does not work:

const selectedAppBundles = await db.query.appBundles.findMany({
  where: (appBundles, { and, isNull }) => and(isNull(appBundles.deletedAt), isNull(appChannels.deletedAt)),
  orderBy: (appBundles, { desc }) => desc(appBundles.createdAt),
  offset,
  limit,
  with: {
    appChannel: true,
  },
});

const selectedAppBundles = await db.query.appBundles.findMany({
  where: (appBundles, { and, isNull }) => and(isNull(appBundles.deletedAt), isNull(appChannels.deletedAt)),
  orderBy: (appBundles, { desc }) => desc(appBundles.createdAt),
  offset,
  limit,
  with: {
    appChannel: true,
  },
});

What is the best way to implement this?

Filter included relations

Similar Threads

Filter included relations

Similar Threads

Similar Threads

Similar Threads