Query Builder

The Query Builder preferences customize SQL queries that you perform in Query Builder.

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.