Overview
Infocapture projects and tickets are stored within the Claromentis database, this guide is designed to help you navigate around both MySQL and MS SQL tables should you need to access Infocapture data.
IMPORTANT: this guide only works if you have direct access to the database in an on-premise deployment and must be carried out by a trained Database Administrator (DBA). Please be aware querying a database directly carries some risk to the data. It is advisable to make a backup and create a custom database view of the existing tables to query data in order to maintain database integrity.
Tables
All Infocapture projects and tickets are stored in a table with prefix "hd" and "fb"
Tables
Here is an example of a ticket submitted under Research & Development Project (Form ID: 11)
We're currently looking at a Ticket with ID: 4
fb_field_data : table containing the value of each field from multiple form data
fb_form_data: a table containing each submission of the form including the date submitted and by whom (user ID) with reference to form ID.
hd_issue: a table containing a list of each individual ticket with its status and reference to which InfoCapture project and form_data_id.
fb_form: a table containing a list of all forms including version, date created, modified and its properties
hd_project: a table containing the current InfoCapture project including the description and its status
