BookmarkSubscribe
Choose Language Hide Translation Bar
Highlighted
Françoise
Community Trekker

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

0 Kudos
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
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
Community Trekker

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

Thanks very much! It's OK!

0 Kudos
Françoise
Community Trekker

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!

0 Kudos