Hello, new to the channel and Prisma - wondering h...
# orm-helpc
cfree
11/17/2018, 6:09 PMHello, new to the channel and Prisma - wondering how to do filtering with Enums. (I don't see a lot of documentation on using Enums for roles and permissions, so if there's a better way, I'd love to hear about it). Basically I'm trying to write a query that pulls all users that have two different enum statuses.
My schema:
Copy code
type Query {
candidates(role: Role!, accountStatus: AccountStatus!): [User]!
}
type User {
id: ID!
firstName: String!
lastName: String!
roles: [Role!]!
accountStatus: AccountStatus!
} Copy code
candidates(parent, args, ctx, info) {
return ctx.db.query.users({
where: {
role: args.role,
accountStatus: args.accountStatus,
},
}, info);
}, Copy code
query CANDIDATES_QUERY {
candidates(role: FULL_MEMBER, accountStatus: ACTIVE) {
id
firstName
lastName
}
}cfree
11/17/2018, 6:11 PMSadly, since the
RoleUserWhereInputcfree
11/17/2018, 6:12 PMI really just want to filter the users with an AND operator, but I can't figure that out
cfree
11/17/2018, 6:14 PMThe error message from running the query:
Copy code
{
"data": null,
"errors": [
{
"message": "Variable \"$_v0_where\" got invalid value {\"role\":\"FULL_MEMBER\",\"accountStatus\":\"ACTIVE\"}; Field \"role\" is not defined by type UserWhereInput.",
"locations": [
{
"line": 2,
"column": 3
}
],
"path": [
"candidates"
]
}
]
}cfree
11/17/2018, 6:14 PMShould I be using directives to handle roles/permissions instead??
cfree
11/17/2018, 6:23 PMMy approach doesn’t feel secure…
h
hinsxd
11/18/2018, 7:41 AMyour
Userrolesrolehinsxd
11/18/2018, 7:43 AMSo change your resolver to
Copy code
where: {
roles_in: args.role
}c
cfree
11/26/2018, 2:37 AM@hinsxd unfortunately there is no
roles_inrolesh
hinsxd
11/26/2018, 2:40 AMoh sorry
hinsxd
11/26/2018, 2:40 AMit should be
role_inhinsxd
11/26/2018, 2:41 AMwith
Copy code
enum Role {
Customer
Author
}role_inc
cfree
11/26/2018, 2:41 AMI’ll look again, I didn’t see it……
cfree
11/26/2018, 2:42 AMwasn’t sure if there enums weren’t allowed in collections
h
hinsxd
11/26/2018, 2:46 AMoh thats right
hinsxd
11/26/2018, 2:46 AMi tried enum collections but doesnt work too
c
cfree
11/26/2018, 2:47 AM😅 ok, I’m not crazy
h
hinsxd
11/26/2018, 2:49 AMperhaps you need to check it manually after query
c
cfree
11/26/2018, 2:51 AMI do…
Copy code
hasRole(currentUser, ['ADMIN', 'EXECUTIVE_COMMITTEE']);2 Views