OdataQuery ignore property from filtering

[Kebechet]

Currently we have this oData query wrapper

using Microsoft.AspNetCore.OData.Query;
using Microsoft.OData.Edm;

namespace ButcaCore.Persistence.OData;

/// <summary>
/// Supports OData query options for IQueryable & IEnumerable collections.
/// $filter
/// $count
/// $orderby
/// $skip
/// $top
/// $select
/// Ignored ones: $count, $expand
/// </summary>
public sealed class ODataService
{
    private readonly IHttpContextAccessor _httpContextAccessor;
    private readonly IEdmModel _edmModel;
    private readonly ODataQuerySettings _oDataQuerySettings = new()
    {
        IgnoredQueryOptions = AllowedQueryOptions.Expand | AllowedQueryOptions.Count,
        HandleNullPropagation = HandleNullPropagationOption.False
    };
    public ODataService(IHttpContextAccessor httpContextAccessor, IEdmModel edmModel)
    {
        _httpContextAccessor = httpContextAccessor;
        _edmModel = edmModel;
    }

    /// <summary>
    /// Applies OData $filter query option to the provided IQueryable collection.
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="query"></param>
    /// <returns></returns>
    public IQueryable<T> ApplyODataFilter<T>(IQueryable<T> query)
    {
        var queryOptions = GetQueryOptions<T>();
        if(queryOptions.Filter is null)
        {
            return query;
        }

        return (IQueryable<T>)queryOptions.Filter.ApplyTo(query, _oDataQuerySettings);
    }


    //internal implementation
    private ODataQueryOptions<T> GetQueryOptions<T>()
    {
        var odataContext = new ODataQueryContext(_edmModel, typeof(T), path: null);
        return new ODataQueryOptions<T>(odataContext, _httpContextAccessor.HttpContext!.Request);
    }
}

And in ApplyODataFilter I would like to ignore filtering based on value e.g. Lastname.
So if the query contains $filter=Firstname eq 'John' and Lastname eq 'Smith'. I would like to say on the backend ignore the Lastname in the filtering,

Why would I want something like this?
Because some fields in our queries can be filtered on the DB level but some are calculated only in memory. And this way I would like to at least prefilter what we can in the DBs and the rest will be done in-memory.

Is something like that possible?

[xuzhg]

@Kebechet Did you try to customize the 'IFilterBinder' to ignore certain node binding?
You can refer to https://devblogs.microsoft.com/odata/customizing-filter-for-spatial-data-in-asp-net-core-odata-8/

If you still need more help on this requirement, feel free let me know or please email to: [email protected] for quick rely.

thanks.

[Kebechet]

Hi @xuzhg
thanks for the reference. Just came back from vacation so I will take a look in following days.