MongoDBFiltering on IExecutable query does not do case insensitive filtering

[parihatch]

Hi,
I have a query that was previously returning IEnumerable<EntityType>. It uses a custom Hotchocolate Filter Convention to do Case Insenstive contains and it works.

Now I changed the query to return IExectuable<EntityType>. This uses the Hotchocolate.Data.MongoDb package and is used with a scope as explained in https://chillicream.com/docs/hotchocolate/v13/integrations/mongodb. However I see that the query now does not do case insensitive contains. I have applied collation with strength = 2 (case insensitive compare) as a filter option in Find.

DI: [Note some queries are still using hotchocolate filtering, hence both AddFiltering and AddMongoDbFiltering are present]

       .AddMongoDbFiltering("mongo")
        .AddFiltering<CustomFilteringConvention>()
        .AddMongoDbSorting()
        .AddSorting()
        .AddMongoDbProjections()
        .AddMongoDbPagingProviders()
        .UseDefaultPipeline()
        .AddErrorFilter<GlobalErrorFilter>()
        .SetRequestOptions(p =>
        {
            var options = p.GetRequiredService<IOptions<GraphQLOptions>>();

            return new HotChocolate.Execution.Options.RequestExecutorOptions
            {
                ExecutionTimeout = TimeSpan.FromMinutes(options.Value.RequestTimeoutMinutes)
            };
        });

Query:

[UseOffsetPaging(IncludeTotalCount = true)]
    [UseFiltering(Scope="mongo")]
    [UseSorting]
    [Authorize(Policy = Policy.Name.LicensedOrServiceUsers)]
    [GraphQLDescription("Get tags")]
    public IExecutable<TagAggregate> GetTags(
        GetTagQueryInputParams? input,
        [Service] IHttpContextAccessor httpContext
    )
    {
        // Service-Service call do not have orgId, hence orgId filter should be skipped
        var isServiceCall = httpContext.HttpContext!.User.IsServiceCall();

        List<FilterDefinition<TagAggregate>> filters = [];

        if (input?.Configured != null)
        {
            filters.Add(
                TagAggregateFilters.ConfiguredOrNotConfiguredTagsAttributesFilter(
                    input.Configured.Value
                )
            );
        }
        if (input?.UnitTypes != null)
        {
            filters.Add(TagAggregateFilters.UnitTypeTagsFilter(input.UnitTypes));
        }        
        var compoundFilter = Builders<TagAggregate>.Filter.And(filters);
        return tagRepo.FindAsExecutable(compoundFilter, skipGlobalFilter: isServiceCall);
    }

Test query: (does not produce results as the actual tagNames contains "Server")

query getTags(
  $take: Int
  $skip: Int
  $unit: String
  $unitTypes: [String!]
  $configured: Boolean
) {
  tags(
    input: { unit: $unit, unitTypes: $unitTypes, configured: $configured }
    take: $take
    skip: $skip
    where: {
      siteId: { eq: "0fd88d7a-6574-41f1-8f70-972dd64b7383" }
      source: { eq: "SENSOR" }
      selected: { eq: true }
      tagName: { contains: "server" }
    }
  ) {
    items {
      tagName
    }
    totalCount
    pageInfo {
      hasNextPage
      hasPreviousPage
    }
  }
}