Storage format

With Elements Connect 6 the storage format for Elements Connect fields changed from XML (Elements Connect 5) to JSON. In this article we will introduce you to the new format, explain how it works and how to manipulate it.

Where is the data stored?

No matter which version of Elements Connect you use, for user and text Elements Connect fields data are stored in the TEXTVALUE column of the CUSTOMFIELDVALUE table. For date and datetime Elements Connect fields, values are stored as timestamp in the DATEVALUE column of the CUSTOMFIELDVALUE table.

In a project, if you already retrieve the Elements Connect 5 (XML) value directly in your code, it will not be compatible with Elements Connect 6.

We do not recommend you to access data directly, use the Elements Connect APIs instead.

Elements Connect API

Elements Connect has a Java API and a REST API that allow you to manipulate fields. See the pages Java API or REST API for more details.

Storage format across versions

This table shows only storage format differences across Elements Connect versions. For more informations about Elements Connect fields look at the different field type page.

Name

Storage format (Elements Connect 5)

Storage format (Elements Connect 6)

Live Text

CHANGED

Single value

JS

<content>
	<value>KEY</value>
</content>

Multi value

JS

<content>
	<value>KEY-1</value>
	<value>KEY-2</value>
	...
	<value>KEY-N</value>
</content>

Single value

JS

{
    "keys":["KEY"]
}

Multi value

JS

{
    "keys":[
		"KEY-1", "KEY-2", ..., "KEY-N"
	]
}

Live User

CHANGED

Single value

CODE

<content>
	<value>john.duff</value>
</content>

Multi values

CODE

<content>
	<value>john.duff</value>
	<value>john.doe</value>
	<value>john.leehooker</value>
</content>

Single value

The field key, as returned by the query

CODE

john.duff

Multi values

The field keys, as returned by the query, separated by \n.

CODE

john.duff\njohn.doe\njohn.leehooker

Live Text (Legacy)

CHANGED

Single value

JS

<content>
	<value>KEY</value>
</content>

Multi value

JS

<content>
	<value>KEY-1</value>
	<value>KEY-2</value>
	...
	<value>KEY-N</value>
</content>

Single value

JS

{
    "keys":["KEY"]
}

Multi value

JS

{
    "keys":[
		"KEY-1", "KEY-2", ..., "KEY-N"
	]
}

Snapshot Text

N/A

Not available in this version.

CODE

The value as seen in the issue

Snapshot Date

UNCHANGED

Value is stored as a Timestamp in the datevalue column of the customfieldvalue table in Jira DB

Snapshot Datetime

UNCHANGED

Value is stored as a Timestamp in the datevalue column of the customfieldvalue table in Jira DB