Query Editor

The following are details about options of this category. See the dialog.

Auto join

Specifies the options for auto joins.

• Join on foreign keys
  Specifies to automatically join tables in a query through a reference from Table A to a primary key in Table B. For example, an order form in Table A shows information on purchases that are made by a customer. It can also show this customer's ID #. The customer ID # refers to a record in Table B which lists a specific address, phone number, name, and so on for the customer. The customer ID # in Table A is a foreign key because it links the customer's ordering information in Table A to the customer's information in Table B.
• Join on primary keys with same names
  Specifies to automatically join tables in a query through a field or a combination of fields that uniquely and specifically identifies a record. For example, your credit card number is a primary key because it specifically links to your birthday, credit history, address, and so on.
• Join on same name
  Specifies to automatically join tables in a query through a link between two columns of the same name in two different tables.

Pre-join

Specifies the default settings for pre-joins.

• Show warning message when adding tables
  With the pre-join feature, when a table is added to a query, other tables may also need to be added in order to form a per-join path. This checkbox specifies whether the adding table warning message should be displayed.

Preview Result Set

Specifies the default settings for previewing a result set.

• Maximum Number of Records
  Specifies the default total number of records that will be displayed when you previewing a query.
• Maximum Number of Records per Page
  Specifies the default maximum number of records to be displayed on one page when previewing a query.

Additional Options

Specifies the additional options.

• Show table names
  If selected, the table that each column belongs to will be displayed in the criteria panel of the Query Editor.
• Show mapping names
  If selected, the full name of the column in the table will be displayed in the criteria panel of the Query Editor.
• Warn when Cartesian product exists
  Specifies whether or not to display a warning when a Cartesian exists. A Cartesian product is used when tables link together with no specifications.

  For example, Table A has three values: A, B and C and Table B has three values: 1, 2 and 3. Value A matches value 1, value B matches value 2, and so on. This is a specific match.

  A Cartesian product could have value A matching with 1, 2 and 3, and value B matching with 1, 2 and 3, and so on. Depending on the data values Cartesian products can produce large and complicated datasets since unnecessary information may be contained.

• Automatically add quotation marks on input values
  Enables JReport Designer to add quote marks automatically after a String type value is inputted into the second Expression text box in the AND format when you specify certain criteria for the fields to be retrieved from the database.

Restore Defaults

Restores values of all options to be the default ones.