Prisma

Is there a way to query for an individual shop that belongs to a user?

```type User {
  id: ID! @id
  shops: [Shop!]! @relation(name: "ShopsUsersRelation")
}

type Shop {
  id: ID! @id
  users: [User!]! @relation(name:"ShopsUsersRelation",link: INLINE)
 }```

Its pretty common to get the shop for an id AND is also owned by the user requesting it

single query assumes you know that ID its that simple so you use the multi query that returns the array

in the future they might add more flexiblity to single item query

this should be something like
```
query {
  shops(where:{
   id: "YOUR_SHOP_ID"
   user: {
     id: "YOUR_USERS_ID"
   }
  }) {
    id
    name
   user {
      id
   }
  }
}
```

if you check your docs on playground the user should accept and `UserWhereInput` nested in your `ShopsWhereInput`

I have now added a method to the top of my resolver to basically grab and return the shop by its ID and the user signed in

```const userHasAccess = async (ctx, id) =&gt; {
	const shops = await ctx.db.shops({ where: { id, users_some: { id: auth.getUserId(ctx) } } })
	if (shops.length &gt; 0) {
		return shops[0]
	} else {
		return false
	}
}```

yeah sorry I was a little unclear users_some is part of the UserWhereInput under your ShopsWhereInput

you could also use the user_some with a unique constraint

because I thought you said that user id was part of the req

I think what i have now is the only solution because of the missing API’s from prisma to mongo