I m trying to write a Query `filterUser` that given the name Prisma #orm-help

I'm trying to write a Query `filterUser`, that giv...

serum

12/30/2018, 10:46 AM

I'm trying to write a Query

filterUser

, that given the name of a friend, say alice, returns all users that are friends with alice. to achieve this, I need to be able to filter users based on the name of the friends-relation, but afaics the prisma client currently (?) doesn't allow this. do I need to implement the filter in the resolver myself, or am I missing something here?

Harshit

12/30/2018, 4:13 PM

Can you share your datamodel so that I can help you 🙂

serum

12/30/2018, 4:34 PM

my datamodel for this is basically:

Copy code

type User {
  id: ID! @unique
  name: String!
  friends: [User!]!
}

serum

12/30/2018, 4:37 PM

now I'd like to define a query like:

Copy code

type Query {
  usersFriendsWith(name: String!): [User!]!
}

such that given a name, I get every user, that's friends with that user

serum

12/30/2018, 4:37 PM

well,

name

should be

@unique

in this example too, I guess

serum

12/30/2018, 4:39 PM

I'm currently investigating adding another field, in order to have a two-way relation, which should make this possible

Harshit

12/30/2018, 4:40 PM

Yes @unqiue makes field available in

UniqueInput

serum

12/30/2018, 4:42 PM

this example is a bit contrived to be honest though. in reality I have a more complicated datamodel that doesn't have self-relations, but the idea should be the same

serum

12/30/2018, 4:47 PM

Copy code

type Bla {
  foos: [Foo!]!
}

type Foo {
  text: String!
}

type Query {
  findBlasWithFooTextContaining(search: String!): [Bla!]!
}

serum

12/30/2018, 4:49 PM

so, in order to define the query, I basically need to add a field

parentBla

Foo

, so that I can first filter

foos()

, and then somehow map

parentBla

over the result?

4 Views

Open in Slack

Previous Next