cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Françoise
Level V

How to get "AND" in filter in sql query builder with JMP14

Hi,

 

with the sql query builder, we can add several filters like the picture below. We have always "OR" with the filters. Could it be possible to have "AND" instead of "OR"?

 

 

 

sql pb filtre.png

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Community Manager

Re: How to get "AND" in filter in sql query builder with JMP14

To get AND just add your additional variables to the filter by selecting them and clicking the "Filter" button.

QueryBuilder Filter.gif

You can use shift- or ctrl-click to select multiple columns and click the filter button once.

QueryBuilder Filter2.gif

-Jeff

View solution in original post

3 REPLIES 3
Jeff_Perkinson
Community Manager Community Manager

Re: How to get "AND" in filter in sql query builder with JMP14

To get AND just add your additional variables to the filter by selecting them and clicking the "Filter" button.

QueryBuilder Filter.gif

You can use shift- or ctrl-click to select multiple columns and click the filter button once.

QueryBuilder Filter2.gif

-Jeff
Françoise
Level V

Re: How to get "AND" in filter in sql query builder with JMP14

Thanks very much! It's OK!

Françoise
Level V

Re: How to get "AND" in filter in sql query builder with JMP14

I've posted another question the same day about the sql.

M. Perkinson, have you the answer because I'm stuck!