For the latest version of JMP Help, visit JMP.com/help.


Using JMP > JMP Preferences > Query Builder
Publication date: 04/28/2021

Query Builder

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

Figure 13.22 Query Builder Preferences 

Table 13.21 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.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).