JMP 12 Online Documentation (English)
Discovering JMP
Using JMP
Basic Analysis
Essential Graphing
Profilers
Design of Experiments Guide
Fitting Linear Models
Specialized Models
Multivariate Methods
Quality and Process Methods
Reliability and Survival Methods
Consumer Research
Scripting Guide
JSL Syntax Reference
JMP iPad Help
JMP Interactive HTML
Capabilities Index
JMP 13.2 Online Documentation
Using JMP
•
JMP Preferences
• Query Builder
Previous
•
Next
Query Builder
The Query Builder preferences customize SQL queries that you perform in Query Builder.
Query Builder Preferences
Preferences on the Query Builder Page
Preference
Description
Automatically join tables added to a query
Automatically joins database tables in Query Builder based on keys and common column names. This option is selected by default. Deselect this option to prevent memory issues with large databases.
Maximum number of levels for a Check Box List filter
Specifies whether the filter for a categorical variable is added as a Check Box List filter. By default, when you add a categorical variable that has more than 1,000 levels, the filter is added as a Like or Not Like filter. You can change the filter to a Check Box List in Query Builder.
Refresh the preview when a change occurs
Updates the data view on the Query Preview tab when a change occurs. This option is selected by default.
Run the preview update in the background
Updates the data view Query Preview tab without displaying the status so that you can continue to work while the queries run. This option is selected by default.
Run queries in the background when possible
Runs database queries without displaying the status so that you that can continue to work Query Builder while the queries run. This option is selected by default.