Sync Logic

Owned by Marina Dittrich (Deactivated)
Last updated: Apr 19, 2023 by Santa Rudzite
2 min read

Custom Fields and Database Columns used by Sync Logic

Jira Field

Database Column

Note

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

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.
Safe issue_id and issue_status.

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.
Safe issue_id and issue_status.

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

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.
Safe issue_id and issue_status.

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.
Safe issue_id and issue_status.

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