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
good point.
Similar wish for Data Filters in JMP:
data filters, new option: "not"
There is a function to "invert" the selection - but this is far away from NOT selecting specific entries.
The resulting selection will just fit to the current snapshot - but could be wrong (!!!) for a future version of the table.
The befit with SQL Filters:
the is the option to create the filter manually:
Thank you for submitting this request!
