Querying NOT NULL GraphQL with Prisma

Question

Schema:

type TrackUser {
  id: ID! @unique
  createdAt: DateTime!
  user: User #note there is no `!`
}
type User {
  id: ID! @unique
  name: String! @unique
}

I want to get Alls TrackUser where User is not null. What would be the query?

Answer 1

This would be a possible query:

query c {
  trackUsers(where: { NOT: [{ user: null }] }) {
    name
  }
}

Here you can see how it looks in the Playground. I added a name to Trackuser in the datamodel in order to be able to create it from that side without a user.

Answer 2

this works, but I guess it is just a hack..

query TrackUsersQuery($orderBy: TrackUserOrderByInput!, $where: TrackUserWhereInput, $first: Int, $skip: Int) {
  trackUsers(where: $where, orderBy: $orderBy, first: $first, skip: $skip) {
    id
    createdAt
    user {
      id
      name
    }
  }
}


variables = {
  where: {
    user: {
      name_contains: ''
    }
  }
}

UPDATE:

For Prisma2, here you have the possibilities:

For products that have no invoice, you can use the following:

const data = await prisma.product.findMany({
    where: {
      invoices: {
        none: {
          id: undefined,
        },
      },
    },
})

And for Invoices that do not have a product associated:

const data = await prisma.invoice.findMany({
    where: {
      productId: null,
    },
})

more details here: https://github.com/prisma/prisma/discussions/3461