Once a Data Warehouse Rule has been created by the Jira Admin the app starts the reporting of Jira changes based on this rules:
If the end user creates an issue in a project matching to the rule, the app inserts immediately a corresponding raw in the reporting table
Every custom or system will be stored as a column in the reporting table
If the end user changes an issue in a project matching to the rule:
If the database raw already exist, the app updates the reporting table
if the database don’t exist, the app creates a corresponding raw in the reporting table
When the rule is created and several issues matching to the rule exist in the system, the admin can make a bulk change of the issue (e.g. add a Label and then remove it) to store all previous issues in the reporting table.
The tables created by the app should NOT be changed by DB Admins to ensure a correct operation.
The following technical columns always exist for every reporting table:
id: technical IDs of Jira issues
serverid: the unqiue Jira server ID
vip_lean_ver: version of the app
row_created: timestamp set by the app after creation
row_updated: timestamp set by the app after update