Many to Many relation through joint table returns null value

[vOtto]

I have my model many to many relation in my model:

Posts have many categories and categories might have many posts type Post

{
  id: Int,
  userId: Int,
  title: String,
  category: [Category]
}

and

type Category {
  id: Int,
  postId: Int,
  name: String
  description: String,
  upTick: Int,
}

through a PostCategories table.

create mutation works just fine.

 categoryId | postId 
---------------------------
 1                  | 2

but when I try to Query categories on posts im getting null as result, query:

{
post(id:2){
  category {
    name
  }
}
}

and result:

{
  "data": {
    "post": {
      "category": null
    }
  }
} 

updated:
resolver for category
Query: { category(root, id) { return db.category.findOne({ id }).then(collection => collection.dataValues); }, },
and for post
Query: { post(root, { id }) { return db.post.findOne({ id }).then(collection => collection.dataValues); },
any ideas?

[JacobT14]

Can you post your resolver code? Just for future reference, this is a question better suited for Stack Overflow!

[vOtto]

Updated.

[JacobT14]

On your post type, what does the resolver look like for the category field?

[vOtto]

I think thats the issue, cause i have none.

[vOtto]

thanks alot

[JacobT14]

No problem! You should be able to just return root.categories, whatever the db field is called