How to filter a database query?

Well, combining two functions in one select (a separate selection and the selection of all values at once) requires a different, more complex approach.

The most rational solution that comes to mind is as follows:

  1. To get all the values in the input without overloading the client part with unnecessary actions, you will need to slightly supplement the server action, which is responsible for supplying values for the select. You will need to add another Set Value step with all the values that you use in the select combined into a string. It looks like this:

  2. Then in the select, instead of %, you select the value Set Value, which will come in parallel with the query for the select:

  3. After that, you will have to redo your “odcfrm " filter. Because in it you use equal, which works as a strict equality and will not work in the case of the “select all” option. For the filter to work correctly, you need to change the condition from equal to in, and specify the following values in the value: {{$_GET.odcfrm. split(",")}}

In this case, you will get what you need