Hi everyone, how to get categories which have chil...
# orm-help
b
Hi everyone, how to get categories which have children ( children.length > 0)?
Copy code
type Category {
  id: ID! @unique
  name: String!
  description: String
  parent: Category @relation(name: "SubCategories")
  children: [Category!]! @relation(name: "SubCategories")
}
here is my answer if someone need fast parrot
Copy code
query {
  categories(where:{
    children_some: {
      id_not:null
    }
  }) {
    id
    name
    	children {
    id
    name
  }
  }
}