cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP Wish List

We want to hear your ideas for improving JMP software.

  1. Search: Please search for an existing idea first before submitting a new idea.
  2. Submit: Post your new idea using the Suggest an Idea button. Please submit one actionable idea per post rather than a single post with multiple ideas.
  3. Kudo & Comment Kudo ideas you like, and comment to add to an idea.
  4. Subscribe: Follow the status of ideas you like. Refer to status definitions to understand where an idea is in its lifecycle. (You are automatically subscribed to ideas you've submitted or commented on.)

We consider several factors when looking for what ideas to add to JMP. This includes what will have the greatest benefit to our customers based on scope, needs and current resources. Product ideas help us decide what features to work on next. Additionally, we often look to ideas for inspiration on how to add value to developments already in our pipeline or enhancements to new or existing features.

Choose Language Hide Translation Bar

Query Builder - filter option on field names to show those not already in Query

Many tables I work with in Query Builder have many field names.  Sometimes I have an existing query and want to add a few additional fields.  The search field might not help if the field name is abbreviated differently than I expected.  The visual of italics when a field is already in the list helps some, but it is hard to turn my brain on/off as I scroll through the list to find the non-italicized field name I'm looking for.  It would be very helpful to have a filter on the search field at the left of query builder to only show the fields NOT already used in the main query build (not selected).  It should work with the filter you already have for highlighting one table and only seeing the fields for that table.  This is an "ease of use" idea.  I can get around it, but it is frustrating because it seems like it could be a relatively easy filter to add.

 

I asked if there was an option to do this at the JMP training at my company, and they thought it was a very useful idea that was not currently available and suggested I enter it here. 

 

Example:  In the image below, a filter for "Fields not in Query" would show just Order_Type and Customer as those are the only fields not in italics (not in the query).  I assume it would be accessed from the red triangle.

LoveDataViz7_0-1699549754045.png