How to filter inner collections in mutations?

[alexander161198]

Hello!

I have 2 objects: Hotel and Room:

public class Hotel
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public int Rating { get; set; }
        public List<Room> Rooms { get; set; }
    }

public class Room
    {
        public int Id { get; set; }
        public string Number { get; set; }
        public bool IsDirty { get; set; }
    }

So, Hotel contains collections of Rooms. How can I use filter by Rooms with where in update Hotel mutation?

For example, I want to rename hotels, that have rooms, which id is greater than 83.
I was trying:

mutation
{
  updateHotel(hotel: {name: "NewName"} where: {rooms: {where {id: {gt:83} } } } )
  {
    countObjectsModified,
    operation,
    objectName
  }
}

But this doesn't seem to work. Please, help me.

[PascalSenn]

mutation
{
  updateHotel(hotel: {name: "NewName"} where: {rooms: {some: {id: {gt:83} } } } )
  {
    countObjectsModified
    operation
    objectName
  }
}

[PascalSenn]

can you provide a repro?

[alexander161198]

Do you mean full response?

{
  "errors": [
    {
      "message": "The specified value type of field `any` does not match the field type.",
      "locations": [
        {
          "line": 2,
          "column": 62
        }
      ],
      "path": [
        "updateHotel"
      ],
      "extensions": {
        "fieldName": "any",
        "fieldType": "Boolean",
        "locationType": "Boolean",
        "specifiedBy": "http://spec.graphql.org/June2018/#sec-Values-of-Correct-Type"
      }
    }
  ]
}

[PascalSenn]

sorry
my bad

mutation
{
  updateHotel(hotel: {name: "NewName"} where: {rooms: {some: {id: {gt:83} } } } )
  {
    countObjectsModified
    operation
    objectName
  }
}

[alexander161198]

It works. Thank you!

[PascalSenn]

Cool :) updated the answer