How to make a realtime filter (signalR)?

Question

.NET

It is necessary to make, as it were, a catalog of goods that will be updated in real time. Now I use vue and .net core, signalR.
The problem is in search, filters and sorting. If the user has a filter by manufacturer, then when adding a product with this manufacturer, the product should appear for the user, but not with another manufacturer (logically...).
As implemented now:
There is a plate in the database where the SignalR Connection Id and all filter, sorting and manufacturer settings are stored.
When adding a new product, I follow the plate and choose those that suit me.
When deleting a product, I just throw a signalR event like "product:delete:${product_id}", and on the client I make subscriptions for the products that are currently displayed. For editing, everything is the same as for deleting.
But I don’t really like it all, can you tell me how to do it better with the current stack or maybe there are some tools that can do what I need (which can be integrated into the .net core)
Everyone, thanks in advance!