Filtering inner collections with where clause not working

[durajetz]

I am trying to filter my authors (inner collection) list of objects with where clause using where arguments (any, some, all, none), but the filtering is not having any effect still returns all the records (HotChocolate version 11.3.8) .

GraphQL query:

query {
  GetData(where: { authors: { some: { uuId: { eq: "123" } } } }) {
    authors {
      uuId
    }
    count
  }
}

A simulation for my query method

public AuthorsWithCount GetData()
{
    data = context.Author;
    //filtering here using uuids

    return new AuthorsWithCount 
        {
            authors = data.ToList(),
            count = data.Count()
        }
}

[durajetz]

Solved

I just added the [UseFiltering] annotation at list of authors property inside AuthorsWithCount object

public class AuthorsWithCount 
    {
        [UseFiltering]
        public List<Authors> Authors{ get; set; }
        public int Count { get; set; }
    }

and then changed the graphQL query to this:

query {
  GetData{
    authors (where: { authors: { some: { uuId: { eq: "123" } } } }){
      uuId
    }
    count
  }
}