I would like to filter a table using multiple values in the same filter. According to the normal behavior you can use VALUE1 OR VALUE2 OR VALUE3... in the table filter and it works but I have a new requirement where the "OR" cojuntion must be a ",".
So the question is:
How to use "," as conjuntion instead of "OR"?
Jhon, there is no such function (never has been). You are trying to create an IN clause.
What you can do it adopt the technique I outlined in my blog JDeveloper 184.108.40.206.0: Escape QBE Operators in Filterable Tables | JDev &amp; ADF Goodies
Here I use a special syntax in the filter field to modify the query. I'm looking for '_and_' in the field to then search for the word 'and' in the column. However, you can modify the sample, use your own syntax and return an IN clause.