I’m having a problem trying to query over relations, e.g.

const item = await ctx.db.query.item({
   where: { product: { id: productId } }
});

I get the error

Reason: 'product' Field 'product' is not defined in the input type 'ItemWhereUniqueInput'.

Is there some way to have relations included in

ItemWhereUniqueInput

? This currently looks like:

type ItemWhereUniqueInput {
  id: ID
}

Hi! Is the relation a 1 to 1 relation?

one to many i.e.

type Product { items: [Item!]! }

In other words, many items may have the same product id?

nope, each item has one product id

use

db.query.items

instead of

db.query.item

That's what I was getting at.😛

in your case only

id: ID! @unique

ah ok, so items will give me

ItemWhereInput

correct

Thank you, have been stuck on that for some time! 😅

@nilan, I was just about to experiment to see whether 1-to-1 relations would show up in a WhereUnique input. Do you recall off the top of your head?

no, it doesn't

Yes sir, that's exactly what I figured.