Overview 

Andi was designed from the ground up for user friendliness, and to adapt to any user's skill level and preferences. The Application Preferences is a great place to look for additional options to tailor your experience in Andi.

• General

• Charting

• UI Look and Feel

• Result Panel

• Connection

• XSLT

• Scripting

• Email

• Default Formatters

You can access the Andi Application Preferences through the Preferences menu, and then by selecting Application:

Open

General 

The General Preferences include options for:

• How often the Andi application will auto-save in its current state (default is 10 minutes)

• Auto-save the current Window Positions (size of dialog, where windows are positioned on screen)

• How often to perform automatic upgrade checks (default is every 30 days), or set to 0 to disable automatic upgrade checks

• Choose from numerous Font styles and sizes to uniquely display SQL text in the Andi Query Editor

Open

Charting 

Charting preferences provide a mechanism to override the default provided Andi.chartTheme included with Andi. You can create a custom theme at any time using the built in Andi theme as a template and then click Apply to save it as the default theme. The next time you create a chart the theme will be used. You can also create multiple themes and apply each at different times to create very different looking charts.

Refer to the Custom Chart Theme article for more information.

Open

UI Look and Feel

Andi is a Java application and can change it's "Look and Feel" on the fly, allowing the user to choose a style which suits their needs. Each Look and Feel comes with one or more themes. Choose a Look and Feel, then a Theme and you will immediately see the changes. You can try out as many Look and Feels as you would like, they won't be saved until you click Apply. NOTE: Not all changes are immediate so you will need to restart Andi once you choose your Look and Feel. 

Open

Result Panel

The ResultPanel Preferences include options for: 

• Auto-sizing of columns for optimum viewing based on Query result size (25,000 is default)

• Globally enable or disable Formatters 

• Visibly highlight Null values in the Query Results columns 

• Maximum number of file cleanup threads (3 is default) 

• Max characters for text display

• Tooltip text for Clob and SQLXML column types

Open

Connection

The Connection Preferences include options for:

• Auto Connect At Andi startup, the prior Query Panels will be restored. Setting Auto Connect to true will allow Andi to automatically reconnect all connections, otherwise the connection will be dynamically reconnected as needed

• Setting a row limit based on a single statement 

• Setting a row limit for an aggregate 

• The option to set a transaction isolation (Read Committed, Read Uncommitted, Repeatable Read, and Serializable)

Open

XSLT

XSLT (Extensible Stylesheet Language Transformations) is a language for transforming XML documents into other XML documents, or other formats such as HTML for web pages, plain text or XSL Formatting Objects, which may subsequently be converted to other formats, such as PDF, PostScript and PNG.

The XSLT Preferences in Andi include options for:  

• XSLT Search Paths

• XSLT Include Path 

Open

Note: To learn more about XSLT Transformation check out the article Working With XML in the XML Viewer

Scripting

The Scripting Preferences in Andi include options for: 

• Scripting Search Paths

• Number Recently Opened Files (default is 25)

• Additional JAR Files  

Open

Email

Email preferences allows sending emails using the ChartViewer or the Integrated

ChartViewer

While viewing a generated Chart, click the Send Email button to save the Chart to a PNG file and send it as an attachment to a defined distribution list.

Integrated Scripting

Using the emailManager, Integrated Scripting emails can be sent to a distribution list containing one or more email addresses allowing an email with/without an attachment to be sent to all users in the distribution list. The attachment(s) can be any file saved to the file system and can include any file saved previously. This includes a chart saved in the currently executing script which allows for a dynamic report to be sent to a distribution list automatically. To get started, click on the Host Connections tab and click the Add button.

Open

Host Connections

A host connection allows a script to connect to an smtp email server to send an email message to a distribution list. The following example shows how you would use Gmail to send your emails. 

• Apply: Save the Host Connection

• Cancel: Close the dialog without saving changes

Open

Distribution Lists

A distribution list would contain one or more email addresses. When an email is sent using emailManager, it will be sent to each email id in the distribution list.

• Add: Add a new email address to the distribution list

• Delete: Remove the email from the distribution list

• Apply: Save all changes

• Cancel: Close the dialog without saving changes

Open

Default Formatters

The Default Formatters allow users to set global formatting for data results in the Query Editor. This includes options such as what format a Date field should appear in, and how to format timestamps.

Open

Note: For more information regarding data formatting, check out the Help Center article Data Formatting Options!