Below "WHERE Clause editor" is very nice to check queries via built-in functions. But it seems to use it only from "from File > Database > Open Table". I'd like to know how to use "WHERE Clause editor" in JSL not from database.
The Where clause is a Boolean expression. As such, if you have a sample of data in a JMP data table, you could create a numeric data column and use the column Formula Editor to make the expression and test it.
Thank you. But my question is I'd like to check SQL queries within "WHERE Clause editor" not from "File > Database > Open Tab". Because in Query Editor window, there is No helpful tool as like "WHERE Clause editor", I should check query syntex every day. If any tool as like "WHERE Clause editor" in Query Editor exits, it will be very helpful to write queries in Query Editor.
