User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

  • JMP Security Notice: CVE-2026-109618 and CVE-2026-109619

    JMP promptly initiated a review of its products, services, and relevant infrastructure for exposure to CVE-2026-109618 and CVE-2026-109619.

    Our assessment of JMP products has not identified exposure to these vulnerabilities. Where remediation was required within supporting environments, appropriate security updates and controls have been applied and validated.

    We have identified no evidence of successful exploitation or unauthorized access to JMP systems or customer information associated with these vulnerabilities.

    JMP continues to monitor the issue and relevant vendor guidance. No action is required by JMP customers at this time.

  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

Allow normal and NOT (inverse) as filter in Query Builder

Status: Acknowledged Submitted by on ‎02-04-2025 10:24 AM
2 Comments (2 New)

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

 

2 Comments
hogi
Level XIII
‎02-04-2025 02:36 PM
‎02-04-2025 02:36 PM

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:

hogi_0-1738697794537.png

 

Sarah-Sylvestre
Level V
‎05-07-2025 12:14 PM
‎05-07-2025 12:14 PM
Status changed to: Acknowledged

Thank you for submitting this request!