54892_en-US

liliconcom

querybuilder AND filter

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?

 

Re: querybuilder AND filter

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 with an AND filter

cheers,

Stan

 

 

 

Re: querybuilder AND filter

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