Filtering using a udf

[alnotas]

Greetings everyone

I need to be able to filter a resource of mine using a udf as part of the comparison.

I have a table 'Customer' that has some fields that are encoded. I have a Db udf 'nvarchar dbo.DecryptData(byte[])' and I want to be able to write a filter like
/api/v1/customer?filter=equals(DecryptData(firstName),'Theodore')
and this to be translated in the EF Core query like
...WHERE dbo.DecryptData(firstName)='Theodore' ...

Customer.FisrtName is a varbinary field in the Db and is mapped as byte[] in my resource

Is this type of filtering possible?
I've tried by overriding the OnApplyFilter but nothing has worked so far.

VERSIONS USED
JsonApiDotNetCore version: 5.5.1
ASP.NET Core version: 8.0.6
Entity Framework Core version: 8.0.4
Database provider: SQL Server 14.0.2052.1

[bkoelman]

Yes, this is possible without changes to JsonApiDotNetCore itself. And it's actually a lot easier than suggested in the StackOverflow question. I have a working sample available, where the decrypt function nicely composes with existing filter functions such as and/or/not. It also works on includes and nested endpoints, such as /blogs/1/posts.

Unfortunately, our communications have stalled again. I'll share the sample once you've provided the operations minimal repro for #1566 that we discussed over email.

[alnotas]

Greetings Sorry for the miscommunication but I am on my summer leave. I will return to office on August the 19th. Thank you.

…

On Fri, Aug 2, 2024, 10:59 Bart Koelman ***@***.***> wrote: Yes, this is possible without changes to JsonApiDotNetCore itself. And it's actually a lot easier than suggested in the StackOverflow question <https://stackoverflow.com/questions/78758507/jsonapidotnetcore-and-filtering-using-a-udf>. I have a working sample available, where the decrypt function nicely composes with existing filter functions such as and/or/not. It also works on includes and nested endpoints, such as /blogs/1/posts. Unfortunately, our communications have stalled again. I'll share the sample once you've provided the operations minimal repro for #1566 <#1566> that we discussed over email. — Reply to this email directly, view it on GitHub <#1599 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJSHF4H7UGLRKS4W5L5TXZTZPM36PAVCNFSM6AAAAABK77IX7SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENRUHAYDCMBYGE> . You are receiving this because you authored the thread.Message ID: ***@***.***>