Filter list using [UseOffsetPaging] with MongoDb getting error is not supported for mongo paging.

[raisaspagnol]

Hello guys

I'm facing issues using [UseOffsetPaging] and IExecutable with MongoDB. I have the following situation:

I want to create queries by company where it is not necessary for the user to inform the field in the where, ex:

Not

{
  regionsByCompany (where: {companyId: {eq:  "624e2962f697e02dff36f590"}}) {
    items {
      id
      name
    }
  }
}

Yes

Behind it would be a middleware to filter and return according to the user's company.

{
  regionsByCompany  {
    items {
      id
      name
    }
  }
}

This only works if it returns an IExecutable, but when returning an IExecutable I am not able to filter and then return the list because I get the error:

{
  "errors": [
    {
      "message": "The provided source System.Linq.Enumerable+WhereListIterator`1[[Region, xxxxxx, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]] is not supported for mongo paging",
      "extensions": {
        "code": "HC0025"
      }
    }
  ],
  "data": {
    "regionsByCompany": null
  }
}

[UseRegionByCompany]
        [UseOffsetPaging]
        [UseSorting]
        [UseFiltering]
        public IExecutable<Region> GetRegionsByCompany(
           [Service] IServiceRegion _serviceRegion,
           [Service] AuthenticatedUser user)
            => _serviceRegion.GetAllByCompanyAsync(user.CompanyId);

public IExecutable<Region> GetAllByCompanyAsync(string companyId)
        {
            return _repositoryRegion.AsExecutable(); 
        }

I'm trying two alternatives, the first would be to dynamically add the companyId field to where where: {companyId: {eq: "624e2962f697e02dff36f590"}}, I don't know if that's possible.

and the second a middleware that filters the items according to the user's company but with that I get the error "...is not supported for mongo paging".

public class UseRegionByCompanyAttribute : ObjectFieldDescriptorAttribute
    {
        public override void OnConfigure(
            IDescriptorContext context,
            IObjectFieldDescriptor descriptor,
            MemberInfo member)
        {
            descriptor.Use(next => async context =>
            {
                var user = context.GetUser();
                string? companyId = user?.Claims
                        ?.FirstOrDefault(a => a.Type == "CompanyId")?.Value;
                
                // before the resolver pipeline
                await next(context);
                // after the resolver pipeline

                if (context.Result is IExecutable<Region> query)
                {
                    var regions = await query.ToListAsync(new CancellationToken()) as List<Region>;
                    var regionsByCompany = regions?
                        .Where(m => m.CompanyId == companyId);

                    context.Result = regionsByCompany;
                }
            });
        }
    }

Could someone shed some light on how to create a custom filter (UseByCompany) or how I can filter the items and then return the list without resulting in the error "...is not supported for mongo paging".

Thanks guys

[PascalSenn]

How does you startup look like?

[raisaspagnol]

Hi

My startup is

 services
               .AddGraphQLServer()
               .AddAuthorization()
               .AddMongoDbProjections()
               .AddMongoDbFiltering()
               .AddMongoDbSorting()
               .AddMongoDbPagingProviders()
               .AddSpatialTypes()
               .SetPagingOptions(new PagingOptions()
               {
                   IncludeTotalCount = true
               })
               .AddQueryType(d => d.Name(OperationTypeNames.Query))
                   .AddTypeExtension<RegionQuery>()
                   .AddTypeExtension<RegionMutation>()
                   .AddType<RegionType>();

[flier268]

@PascalSenn Any idea?