Clear cached server connect (all calls)

[franse]

Continuing: How can I force the load of a cached server connect with params? (More than one query)

I feel on the need of trying to explain a little more what I'm asking for..

When a server side filtered query is made, if cache is enabled, filtering after a forced reload will result in not updating all the calls that the frontend makes.

Example (just an example, please don't stay on another solution for this because I need to expand this issue to a more complicated one):

The project

In MySQL we have a table let's say a task table:

And we want to use a filter to have both results (All of them/Not completed)

The desired behavior on changing a record, and force a reload is:

And clicking Not completed

This works now because two calls are made:
/api/wapplercommunity/fr_screload?status=
and
/api/wapplercommunity/fr_screload?status=Completed

The issue:

When using cache:

A force reload only load one of them.

Case

Let's say another user change a value:

And force a reload (which it's supposed to be dynamic, probably sockets):
Only change the first one:

And clicking checkbox:

As you can see, the reload method only will reload the first call.
So I'm asking if it's possible to delete ALL keys related to server connect on session storage.

Workaround:

    function clearDataCached() {
  Object.keys(sessionStorage)
    .filter(key => key.startsWith("dmxState-/api"))
    .forEach(key => sessionStorage.removeItem(key));
}

I hope this make the idea a little more clear, thank you all

[Cheese]

You're using client side caching for server side? Have you not considered using Redis on the server side and clearing the key for the cached item server side? Would that not give the desired result @franse?

[franse]

Thanks @Cheese to be honest, used redis for few things, but never integrated with Wappler..
Still on a pending list
This feature request is to allow reload() method to delete all keys on session storage, not only the first one..