Prisma Connection WhereInput for Array of enum values?

Question

Doing this 👇

query {
  postsConnection(where: {
    status: PUBLISHED
  }) {
    aggregate {
      count
    }
    edges {
      cursor
      node {
        id
        slug
      }
    }
  }
}

gives me postsConnection of published posts.

The Post model has an array of Category enum in field categories. This is the Post in datamodel 👇

enum Category {
  TECH
  FIN
  DIGIMARK
  CODING
  TUTORIAL
  HOWTO
  WRITING
  INSPIRE
  SCIENCE
  POLITICS
  LIFESTYLE
}
type Post {
  id: ID!
  title: String!
  editorSerializedOutput: Json!
  editorCurrentContent: Json!
  editorHtml: String!
  updatedAt: DateTime!
  createdAt: DateTime!
  author: User
  authorId: String!
  categories: [Category!]!
  thumbnail: Json!
  status: PostStatus!
  slug: String!
}

My question is, what Prisma Query do I need to write to get PostConnection of posts in a specific category?

You already filter posts in your connection using status: PUBLISHED, you can do the same with categories — Errorname
– Errorname, Commented Mar 30, 2019 at 7:36
That's what the question is. I cannot do that with categories.. it is an array — kumareth
– kumareth, Commented Mar 30, 2019 at 10:14
Oh sorry, didn't quite understood the question, I added a better answer — Errorname
– Errorname, Commented Mar 30, 2019 at 10:17

Errorname · Accepted Answer · 2019-03-30 10:19:25Z

1

Prisma doesn't yet allow filtering with Enum (see issue on github)

You can however make a to-many relation with a new Type Category that you can create

answered Mar 30, 2019 at 10:19

Errorname

2,48115 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Prisma Connection WhereInput for Array of enum values?

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