Query Builder
The Query Builder preferences customize SQL queries that you perform in Query Builder.
Figure 13.22 Query Builder Preferences
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. |