Prisma

How can I do polymorphic relationships? Say I have a `Product` type. And then I have `Book`, `Toy`, `Food`, etc, and I need to associate those with `Product`.

Apparently GraphQL supports polymorphic types

```
searchMedia(name: "abc") {
  ... on Photo {
   height
   width
  }
  ... on Video {
    height
    width
    duration 
  }
  ... on Audio {
    duration 
    key
  }
}
```

Hey <@U59R0U6BA> :wave: Right now you would create multiple relations between those types, resulting in "sparse" data. Once we added support for union types and interfaces, this can be handled much more elegantly: <https://github.com/graphcool/feature-requests/issues/165>

for example if I have a list of products with different relations to the different product types

and I need to filter for one of the attributes of a product type

Can you give an example? Do you mean you want to query all products that have `height &gt; 10`?

correct, but only one type of product has height

yea and you don't know "beforehand" which types do have this property, right?

This situation is indeed quite tricky to model right now without interfaces and unions

and what if I do know which types have height?

However, I'd also say that this is a typical use case for a search provider such as Algolia

so you could use the Algolia integration to sync all the product data to Algolia and use their API to filter the products

if you know which types have the `height`, you can manually build the query to look like this

that must be a pretty long query? :smile:

```
query {
  allProducts(filter: {
    OR: [{video: { height_gt: 10 } }, { photo: { height_gt: 10 } }] 
  }) {
    video {
      id
    }
    photo {
      id
    }
  }
}
```

sorry, was quickly heading out :stuck_out_tongue: