How to export data from the database

The Asset Tracker application data is stored inside the <JIRA_HOME>/data/attachments/ephorData> folder. Please note it is an Apache Derby database, so you'll need a DBMS tool to open it. You can retrieve the data depending on your needs. For example, the Title field value is stored inside a table called FIELDVALUES.

However, that table only contains the values of the fields. If you look at that table alone, it won't give you the information you need. The information is stored across other tables. To find the information, you'll need to build a SELECT statement to JOIN the information across the FIELDVALUES, FIELDS, and FIELDDEFINITIONS tables.

For example, if you only wanted the Titles of the assets, you could use something like this:

select FV.VALUE
  from FIELDVALUES FV
  join FIELDS F
    on F.ID = FV.FIELD_FK
  join FIELDDEFINITIONS FD
    on FD.ID = F.FIELDDEFINITION_FK
where FD.TITLE = 'Title';