What inspired this wish list request?
Currently, the option for filtering in the Query builder is global for all filter, meaning I can either filter for things contained (normal filter) or not contained (checkbox inverse activated) in the filter column
What is the improvement you would like to see?
In SQL, it is very common to use both a filter for data I want (IN in SQL terms) and data I don't want (NOT IN in SQL terms) to further select only the data that meets the conditions I set.
I'd like to set the mode inverse for each filter box separately to chain IN and NOT IN conditions in my query
Why is this idea important?
This is for me a must have since otherwise I'm forced to query large data sets with only IN or NOT IN filters and then have to refine further in JMP by e.g. manually deleting rows, which is quite contrary to the usual logic used in SQL where I only query the stuff I need