[Bug][Jira] start_date Field Empty in sprint Table After Upgrading DevLake from 0.21 to 1.0 with Jira Plugin

[narrowizard]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

After upgrading DevLake from version 0.21 to 1.0 and using the Jira plugin to collect data, we observed that the start_date field in the sprint table is empty.

What do you expect to happen

The start_date field in the sprint table should be populated with the correct values retrieved from the Jira API.

How to reproduce

• Using DevLake version 1.0.
• Set up the Jira plugin to collect data.
• Use Jira Server version 7.12.3 as the data source.
• Check the sprint table in the DevLake database and note that the start_date field is empty.
• Verify the following tables for data consistency:
  • _tool_jira_sprints: The start_date field is also empty here.
  • _raw_jira_api_sprints: The API response includes the start_date field with valid values.

Anything else

Retrieve logic works in 0.21:

incubator-devlake/backend/plugins/jira/tasks/apiv2models/sprint.go

Lines 49 to 51 in 1888cef

	if s.ActivatedDate != nil {
	sprint.StartDate = s.ActivatedDate
	}

But it not works in 1.0:

incubator-devlake/backend/plugins/jira/tasks/apiv2models/sprint.go

Lines 50 to 57 in 8573fbf

	// jira cloud
	if !isServer {
	sprint.StartDate = s.StartDate
	}
	// jira server
	if isServer && s.ActivatedDate != nil {
	sprint.StartDate = s.ActivatedDate
	}

Seems that some version of jira server returns StartDate instead of ActivatedDate.
Snapshot of raw data:

Version

release-v1.0

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct