These are application settings you may change in the Tools – Options popup.

Query

  • Auto Generate Demos – Auto-generate demo queries and models when connection created. Default True.
  • Page Size – Default page size of the grid results. Default 1,000. Between 1 and 1,000,000.
  • Order By Position – ORDER BY 1, 2, … (when available), to avoid repeating long expression. Default True.
  • Order By Alias – ORDER BY alias of SELECT item (when available), to avoid repeating long expression. Default False.
  • Group By Position – GROUP BY 1, 2, … (when available), to avoid repeating long expression. Default True.
  • Group By Alias – GROUP BY alias of SELECT item (when available), to avoid repeating long expression. Default False.
  • Use CTEs – Use WITH when CTEs (Common Table Expressions) supported. Default True.
  • Main Subquery Identifier – Main subquery identifier when using nested queries. Default ‘t___’.
  • Optimize For LEFT JOIN – Try to get as many LEFT JOIN as possible, with fewest RIGHT JOIN. Default True.
  • Use Window Functions – Use window functions when supported. Default True.
  • Fix Nested ORDER BY – Try fix nested ORDER BY subqueries. Default True.
  • Fix Math Problems – Try fix common math problems and/or inconsistencies. Default True.
  • Auto Update Lookup – Update model lookups when set or changed in queries. Default True.
  • Auto Update Format – Update column format when set or changed in queries. Default True.
  • Hide Images – Try showing images as they are in the result grid cells, or hide them and show small icon instead. Default False.
  • Two Column Layout – Two-column layout style of generated query’s SQL. Default True.
  • Auto Resize Grid Columns – Auto-resize result columns to content, after showing data. Default True.
  • Auto Align Grid Columns – Auto-align to the right numeric and date-time columns. Default False.
  • Min Column Width – Minimum width of a column, in Auto Resize mode. Default 30, min 1.
  • Max Column Width – Maximum width of a column, in Auto Resize mode. Default 600, min 1.
  • Hide Row Numbers – Hide query result row numbers from row headers. Default False.
  • Binary Display – Display format of binary data when exported as text. Default ‘(Binary)’.
  • Max Alias Length – Maximum length of internal query aliases. Default 25, min 10.
  • Max Nesting Level – Maximum nesting level for nested subqueries. Default 5, min 1.

Nulls

  • NULL Display – Display format of a NULL value. Default (Null).
  • Use NULLS FIRST/LAST – Use optional NULLS FIRST and NULLS LAST clauses when sorting. Default True.
  • Fix NULL Operations – Try convert NULL into a neutral value when used in simple operations. Default True.
  • Fix NULL Aggregations – Auto-convert NULLs to 0 when field used in COUNT or AVG aggregate function. Default True.
  • Fix NULL Parameters – Automatically try to fix potential problem with NULL value in query parameters. Default True.

Parameters

  • Internal Parameter Name Prefix – Alias prefix for query parameter names. Default ‘param___’.
  • Run with Internal Query Parameters – Always generate and use internal query parameters for user input values, when running queries, to prevent SQL injection. Default False.
  • Generate with Internal Query Parameters – Generate and show internal parameters in query’s SQL. Default False.
  • Query Parameters in Function Calls – Internal query parameters auto-generated in function calls, when using parameters. Default True.
  • Query Parameters in UNION and VALUES – Internal query parameters auto-generated in UNION and VALUES fields, when using parameters. Default True.
  • Query Parameters in Lists – Internal query parameters auto-generated in list values, when using parameters. Default True.
  • Query Parameters in Non-User Values – Internal query parameters auto-generated in internal values, when using parameters. Default False.
  • Dummy Table Name – Required dummy table name used in mandatory FROM clauses. Default ‘dual’.

System

  • Administration Mode – show/hide hidden elements and schema objects. Default False.
  • Days Between Backups – frequency of the internal database backup, performed before closing the application. Default 1, zero or negative to disable.
  • Connection Strings File – file with connection strings, for batch import. Default ConnectionStrings.txt (when property is an empty string), expected in your AppData\Xtractor folder.
  • Max Opened Documents – Maximum number of documents opened at a time. Default 10, min 3.
  • Auto-Collapse on Drill-Down – Auto-collapse all same-level expanded rows before a drill-down. Default True.
  • Show Highlights – Enable/disable auto-highlight when mouse over elements (and nothing selected) in diagrams. Default True.
  • Show Grid – Show/hide grid. Default True.
  • Auto Expand – Auto-expand diagram elements when adding new tables or subqueries. Default True.
  • Copy Print – Print identical image or hide selection frames in PDFs, images and clipboard selections. Default False.

Leave a Reply