CFOS Datastructure
The Custom Field Option Synchroniser app is using an Active Object table within the JIRA database to store the syncing information.
You will find the following tables responsible for the synchronisation.
AO_9C8F64_CFSYNC_CONFIG
In this table, you will find the synchronisation configuration for each custom field.
Column | Type | Description | Example |
|---|---|---|---|
ID | INT | The id of this config in the AO table. | 3 |
CUSTOM_FIELD_ID | BIGINT | The id of the related custom field. | 10100 |
FIELD_CONFIG_SCHEME_ID | BIGINT | The id of the related custom field context. | 10200 |
CF_DATA_SOURCE_ID | BIGINT | The id of the used data source configuration or empty when JNDI data source is used. | |
DATASOURCE | VARCHAR | The JNDI data source name. | jdbc/myDS |
PARENT_SQLSTATEMENT | LONGTEXT | The SQL to return the options. | select id, pname as value from project |
CHILD_SQLSTATEMENT | LONGTEXT | The SQL to return the child options. | |
ERROR_MAIL_ADDRESS | VARCHAR | A mail address, in case of errors a mail containing a description of the problem is sent. | admin@example.com |
AO_9C8F64_CFEXTERNAL_OPTION
This table is important for incremental synchronisation. For example, the add-on stores the Id of the option from the external database EXTERNAL_ID next to the internal JIRA option id CUSTOM_FIELD_OPTION_ID. This gives the add-on the possibility to match the options again, even if the option was renamed.
Column | Type | Description | Example |
|---|---|---|---|
ID | INT | The id of this option in the AO table. | 1 |
CUSTOM_FIELD_ID | BIGINT | The id of the related custom field. | 10100 |
FIELD_CONFIG_SCHEME_ID | BIGINT | The id of the related custom field context. | 10200 |
CUSTOM_FIELD_OPTION_ID | BIGINT | The id in the Jira database of the option | 10200 |
CUSTOM_FIELD_PARENT_OPTION_ID | BIGINT | The id in the Jira database of the parent option | |
DISABLED | TINYINT | Deleted options are disabled. | 0 |
EXTERNAL_ID | VARCHAR | The identifier of option in the external data source | |
EXTERNAL_PARENT_ID | VARCHAR | The identifier of the parent option in the external data source | |
SEQUENCE | INT | The sequence defines the order of the options | 0 |
VALUE | VARCHAR | The value of the option | bitvoodoo support |
AO_9C8F64_CFDATASOURCE
This table stores the configured JDBC data sources.
Column | Type | Description | Example |
|---|---|---|---|
NAME | VARCHAR | The name will be shown in the Option Synchronisation data source selection. | My CMDB |
DATABASE_TYPE | VARCHAR | The selected database type. | MY_SQL |
DATABASE_NAME | VARCHAR | The name of the database to connect | CMDB |
HOST | VARCHAR | The host name or IP address of the machine on which SQL server is running. | localhost |
PORT | VARCHAR | The used port number from the SQL server. | 3306 |
USER | VARCHAR | The user to authenticate against the database. | database_reader |
PASSWORD | VARCHAR | The users' password to authenticate. | ******** |