BookmarkSubscribeRSS Feed

Re: querybuilder AND filter

jumboshrimps

New Contributor

Joined:

Apr 9, 2018

Need to filter on more than one criteria:

ID >='278292'  AND Orderdate >1/1/2018.

 

NOT

ID >='278292' OR Orderdate >1/1/2018, which gives me the wrong answer.

 

Is that possible in QueryBuilder?

 

2 REPLIES
bill_worley

Staff

Joined:

Jul 2, 2014

I didn't see a direct way to do what you are asking for, but there is a bit of work around if you would like to try it.

Pull your query table and run the query to open the JMP table.  From there open the Data Filter under the Rows drop down or hot spot.  You can set up your "And" filter there. Then save the data filter script to a script window.  Copy and past that script into the Post-Query Script toggle in the Query Builder.  Save the query.  When you run that query in the future the data filter will pop up and you can change the data filter as needed.

 

HTH

Highlighted
stan_koprowski

Community Manager

Joined:

Aug 8, 2012

Hi @jumboshrimps,

It is possible to do an AND filtering condition.

The "AND" condition is the default option.

In this example, I selected customerid and dateout as my filter conditions.

Query Builder And Filter.gifQuery Builder with an AND filter

cheers,

Stan