Need to filter on more than one criteria:
ID >='278292' AND Orderdate >1/1/2018.
ID >='278292' OR Orderdate >1/1/2018, which gives me the wrong answer.
Is that possible in QueryBuilder?
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.
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.