JMP 14.0 Online Documentation (English)
Discovering JMP
Using JMP
Basic Analysis
Essential Graphing
Profilers
Design of Experiments Guide
Fitting Linear Models
Predictive and Specialized Modeling
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 Online Documentation
JMP 12 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.
Figure 12.19
Query Builder Preferences
Table 12.18
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.
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.
Maximum number of rows for previews
Limits the number of rows that appear on the Query Preview tab. The default number is 5000.
Keep queries compatible with JMP 12 by default
Maintains query compatibility with JMP 12. When you open a query that is marked JMP 12 compatible in JMP 13 or later, features that create compatibility problems are hidden regardless of how the preference is set.
Maximum number of levels for a Check Box List filter
Determines 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 Contains filter.
Maximum rows in table for which category levels will be automatically retrieved
Specifies the maximum numbers of rows for which unique category levels in the filtered column are retrieved. The minimum value is -1 (no limit). The maximum value is 1 billion. By default, if the categorical column has more than 1 million rows, JMP does not automatically retrieve the unique category levels.
Retrieve category levels for tables whose size cannot be determined
Determines whether category levels are retrieved for a filtered column when the number of rows cannot be determined. Selected by default. If this option is not selected, the filter is added as a Contains filter.
Default filter type for categorical columns
Specifies a List Box as the default filter type for categorical columns.
Fallback filter type for categorical columns
Specifies a Contains filter as the default filter type for categorical columns when the number of rows cannot be determined or the query is canceled.
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.
Previous
•
Next
Help created on 7/12/2018