SQL Database Definition actions

Update AI Model

This button is enabled when Enable AI is checked at the currently-selected definition, and when no outstanding changes at present within the same.  It allows you to update the AI model associated with the definition with details of the definition's attributes (More details on using AI to create criteria within a basic selection rule can be elsewhere within this, and within the Basic Selection Rule, documentation).  Invocation creates an Update model attributes for '[definition name]' job and displays it in the My Jobs dialog.  Further details on the job can be found in the My Jobs documentation.  On completion, the selected definition's Model Last Updated property is updated at the AI tab.

Create New SQL Database Definition

This action is carried out using the Create new SQL Database Definition toolbar button.  The new definition’s name is ‘New SQL Database Definition’ (an incrementable integer can be appended to ensure uniqueness).  Contact rules are enabled automatically at a new SQL database definition.

Configure Existing SQL Database  Definition

This is carried out in the Selected SQL Database Definition Details section.  If you configure a definition that has been saved previously, its State is set to Edited.

Delete Selected SQL Database Definitions

This is carried out in the toolbar.  A deleted definition's State is set to Deleted.  Its row text color is set to red.  You may no longer select a deleted row.  If required, you can delete multiple definitions at the same time.

Save Changes to SQL Database Definitions

Save is carried out using the Save changes to SQL Database Definitions toolbar button.  Any changes you have made are validated, and any validation errors are advised in a dialog.  You may not proceed with the Save until you have resolved them.

Following a successful save, definitions are displayed in alphabetical order.  All states are updated to Unchanged.  Any deleted definitions are removed from display.

Refresh

This option reloads the contents of the interface from the operational database.  If changes have been made, a ‘Save Changes?’ dialog is shown.