Sync Logic
Custom Fields and Database Columns used by Sync Logic
Jira Field | Database Column | Note |
|---|---|---|
issue_updated_data | db_updated_data | Used to identify changes in the database. Can be any value. Comparison occures on string base. |
issue_updated | db_updated | Used to synchronize the Jira updated date to the database. |
issue_status | db_status | Used to synchronize the Jira status to the database. |
All issue updates are executed under the name of the issue reporter. If issue reporter has been deactivated, project lead becomes an active user.
Cron based Sync Logic
Step | Condition | Action | Note |
|---|---|---|---|
1 | Sync Cron starts | ||
Analyse and mark data sets | |||
2 | if issue_updated_data != db_updated_data | Mark issue for update from external database. | |
3 | if issue_status != db_status | Mark issue to update "db_status" in external database. | Only if "Status" synchronization from Jira to database has been configured. |
4 | if issue_updated != db_updated | Mark issue to update "db_updated" in external database. | Only if "Updated" synchronization from Jira to database has been configured. |
Update data in marked data sets | |||
5 | Update Jira issues marked in step 2. | ||
6 | Update database columns "db_status" marked in step 3. | Only if "Status" synchronization from Jira to database has been configured. | |
7 | Update database columns "db_updated" marked in step 4. | Only if "Updated" synchronization from Jira to database has been configured. | |
8 | Copy "db_updated_data" to "issue_updated_data" | ||
End | |||
Full Sync Logic
Step | Condition | Action | Note |
|---|---|---|---|
1 | Full sync is started manually | ||
Analyse and mark data sets | |||
2 | Mark all issues for update from external database. | ||
3 | if issue_status != db_status | Mark issue to update "db_status" in external database. | Only if "Status" synchronization from Jira to database has been configured. |
4 | if issue_updated != db_updated | Mark issue to update "db_updated" in external database. | Only if "Updated" synchronization from Jira to database has been configured. |
Update data in marked data sets | |||
5 | Update Jira issues marked in step 2. | ||
6 | Update database columns "db_status" marked in step 3. | Only if "Status" synchronization from Jira to database has been configured. | |
7 | Update database columns "db_updated" marked in step 4. | Only if "Updated" synchronization from Jira to database has been configured. | |
8 | Copy "db_updated_data" to "issue_updated_data" | ||
End | |||
© 2023, STAGIL